Free Support Forum - aspose.com

Copying a worksheet between workbooks throwing com.aspose.cells.CellsException

Hi,

We are getting below exception while copying worksheet between workbooks :

Exception:
com.aspose.cells.CellsException: Invalid parent XF: 41
at com.aspose.cells.gH.a(Unknown Source)
at com.aspose.cells.bN.b(Unknown Source)
at com.aspose.cells.iV.a(Unknown Source)
at com.aspose.cells.Cell.a(Unknown Source)
at com.aspose.cells.Row.a(Unknown Source)
at com.aspose.cells.Rows.a(Unknown Source)
at com.aspose.cells.Worksheet.copy(Unknown Source)

JAR's Using : aspose-cells-2.5.4.jar , aspose.slides-2.5.0.jar , jai_core.jar ,jai_codec.jar

Sample Source code : attached.
Sample sourse Excel File: attached

We are not able to findout the root cause of the above issue. Please clarify how to avoid and what is the root cause of this Invalid parent XF: 41

Thanks

Hi,


I have checked your source file, it is corrupted and has errors, so you are getting this exception. You may confirm the errors opening the file into MS Excel 2007. See the attached screen shots.

I have checked if you re-save the file into MS Excel (by opening the file in MS Excel), then, Aspose.Cells for Java works fine.

Thank you.