hello,
I am working on spreadsheet cells extraction on ods files.
I am using Aspose.Cells 2.1.0.4 for Java, which is the latest release.
Working on the attached file, I get empty iterator:
Your help is appreciated
Shay
=========================
Workbook workbook= new Workbook();
workbook.open(fileName);
Worksheets worksheets=workbook.getWorksheets();
for (int worksheetNo=0;worksheetNo<worksheets.size();worksheetNo++) {
Worksheet worksheet=worksheets.getSheet(worksheetNo);
Cells cells=worksheet.getCells();
Iterator cellIterator=cells.getCellIterator();
while (cellIterator.hasNext()) { // cellsIterator hasNext is false
Cell cell=cellIterator.next(); // this line is never reached
// take the cell value
}
}