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?