Open Source Software Forum

Aspose generate .xlsx file could not be opened again with Aspose

Hi ,

I have generated the .xlsx file with Aspose Cells Java. This workbook contains a lot of worksheets and many pivots and charts.
Issues are listed below:

  1. Charts and Pivot are not getting updated.
  2. PivotTable.refreshData() throwing an exception

Lastly the generate output couldn’t be loaded again with Aspose - giving below exception.
java.lang.ArrayIndexOutOfBoundsException: 4
at com.aspose.cells.zaoz.a(Unknown Source)
at com.aspose.cells.zaoz.j(Unknown Source)
at com.aspose.cells.zaoz.a(Unknown Source)
at com.aspose.cells.zcqx.b(Unknown Source)
at com.aspose.cells.zd.f(Unknown Source)
at com.aspose.cells.zd.r(Unknown Source)
at com.aspose.cells.zd.a(Unknown Source)
at com.aspose.cells.zapt.a(Unknown Source)
at com.aspose.cells.zjq.a(Unknown Source)
at com.aspose.cells.zjq.a(Unknown Source)
at com.aspose.cells.Workbook.a(Unknown Source)
at com.aspose.cells.Workbook.(Unknown Source)
at com.ibm.pmo.projects.amerisource.TestPivot1.main(TestPivot1.java:22)
Thanks
AnirbanResponse_output.zip (255.4 KB)

This topic has been moved to the related forum: https://forum.aspose.com/t/aspose-generate-xlsx-file-could-not-be-opened-again-with-aspose/226966