We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Ods cells iterator does not work as expected


I am working on spreadsheet cells extraction on ods files.

I am using Aspose.Cells for Java, which is the latest release.

Working on the attached file, I get empty iterator:

Your help is appreciated



Workbook workbook= new Workbook();


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



Hi,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

Thank you for considering Aspose.

Please try the attached latest version of Aspose.Cells for Java. We have fixed your mentioned issue regarding ODS file.

Thank You & Best Regards,

Issue solved,


The issues you have found earlier (filed as 11139) have been fixed in this update.

This message was posted using Notification2Forum from Downloads module by aspose.notifier.