Java POI API Can't read .xls generated by PHPExcel

Nov 25, 2010 at 6:01 AM


I have generated an Excel file 'test.xls', then when I used Java POI API to read the file, I got an Exception 'arning, incorrectly terminated empty data blocks in POIFS block listing (should end at -2, ended at 0)'.

Can anybody help me about this exception?

Thanks all the responses.

Nov 27, 2010 at 10:54 PM

Is it possible to create a workbook in Excel itself that matches the file you are creating with PHPExcel, and prove that it will read correctly with POI; then send us both files so that we can compare the differences.