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?