Error in creating opening the spreadsheet using POI created by Aspose

Aspose.Cells Product Family
1

I am getting the following error when trying to open the spreadsheet using POI when created using Aspose.

Please find the error below:

Caused by: java.lang.ClassCastException: org.apache.poi.hssf.record.UnknownRecord cannot be cast to org.apache.poi.hssf.record.ExtendedFormatRecord
at org.apache.poi.hssf.model.Workbook.getExFormatAt(Workbook.java:787)
at org.apache.poi.hssf.usermodel.HSSFCell.(HSSFCell.java:198)
at org.apache.poi.hssf.usermodel.HSSFRow.createCellFromRecord(HSSFRow.java:200)
at org.apache.poi.hssf.usermodel.HSSFSheet.setPropertiesFromSheet(HSSFSheet.java:180)
at org.apache.poi.hssf.usermodel.HSSFSheet.(HSSFSheet.java:117)
at org.apache.poi.hssf.usermodel.HSSFWorkbook.(HSSFWorkbook.java:287)
at org.apache.poi.hssf.usermodel.HSSFWorkbook.(HSSFWorkbook.java:200)
at org.apache.poi.hssf.usermodel.HSSFWorkbook.(HSSFWorkbook.java:316)
at org.apache.poi.hssf.usermodel.HSSFWorkbook.(HSSFWorkbook.java:297)
at com.gs.fw.gnmr.frames.excelreports.utils.ExcelCopier.createHSSFWorkbook(ExcelCopier.java:120)
at com.gs.fw.gnmr.frames.excelreports.utils.ExcelCopier.copyWithCharts(ExcelCopier.java:104)
... 19 more

Please advise at the earliest.

Thanks

DJ

2

Hi,

Well, if a file (generated by Aspose.Cells) can be opened fine by MS Excel, then it should be a valid file
So, POI should open it fine too. Aspose.Cells generated file follows MS Excel standards, please check to open the generated file (by Aspose.Cells) if it opens fine in MS Excel. Please let us know if you find any difficulty opening the generated file (by Aspose.Cells) into MS Excel, if this is the case, please attach the file here, we will check it soon.

Thank you.

3

Hi DJ,


Please attach the spreadsheet that throws error while opening. If you have created this file using Aspose.Cells API then also provide us the code snippets. We will look into it very soon.
Thank you for your cooperation.