Hello,
I have a method which read all records from an input .ods file, It works 
well especially for multi-line cell.
For multi-line cell i get only the first line and not all the content.
This is my code:
 sheet = SpreadSheet.createFromFile(file).getSheet(2);

                 //Iterating through each row of the selected sheet
                 MutableCell cell = null;

                 for(int nRowIndex = 5; nRowIndex < 20; nRowIndex++)
                 {              
                   //Iterating through each column
            
                   for(  int nColIndex = 0;nColIndex < 11; nColIndex++)
                   {
                     cell = sheet.getCellAt(nColIndex, nRowIndex);
                 
//                     cell.setValue(obj)
                     
excelData[nRowIndex][nColIndex]=cell.getValue().toString();        
                     
                     excelData[5][10]=component;
                     
System.out.println("aaaaaaaaa"+cell.getValue().toString());
                     
                    }

                  } 


How can do with multiples line? someone has an idea please?

Reply via email to