I have encountered error 8228 while attempting to save a Workbook. Unlike some other threads regarding this problem, it is not the result of multiple calls to the save() method, it’s called only once. The file is created, but has a length if 0 bytes.
It is probably worth noting that the workbook created is extremely large. The program converts tables in a Word document into worksheets (one worksheet per Word table). The Word file in question produces 1409 worksheets and when save() is called, the error occurs.
Thanks for any assistance you can provide.
Kent
Hi Kent,
Thank you for considering Aspose.
Please try the attached latest version of Aspose.Cells. If you still face any issue, please share the sample code to reproduce the issue and we will check it soon.
Thank You & Best Regards,
Nausherwan,
Thanks for your reply. Unfortunately, the new Cells jar did not solve the problem. Given the nature of the program, it doesn’t make much sense to try and create sample code, so I’ve zipped the entire development directory (it’s not too large a program at this point). You should be able to open it as a project under an IDE such as Eclipse and run it. The only thing you’ll need to add is your own ‘Aspose.Total.Java.lic’ file in the top level directory (word2excel).
The program opens a Word document, converts its tables to Excel worksheets, and saves the resulting Excel workbook. The exception is thrown in the Word2Excel.convert method from inside Workbook.save(). Here is the exception:
java.lang.ArrayIndexOutOfBoundsException: 8228
at com.aspose.cells.eS.a(Unknown Source)
at com.aspose.cells.eS.a(Unknown Source)
at com.aspose.cells.dL.a(Unknown Source)
at com.aspose.cells.q.a(Unknown Source)
at com.aspose.cells.Workbook.save(Unknown Source)
at com.sonex.word2excel.Word2Excel.convert(Word2Excel.java:199)
at com.sonex.word2excel.Word2Excel.actionPerformed(Word2Excel.java:151)
at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source)
at java.awt.Component.processMouseEvent(Unknown Source)
at javax.swing.JComponent.processMouseEvent(Unknown Source)
at java.awt.Component.processEvent(Unknown Source)
at java.awt.Container.processEvent(Unknown Source)
at java.awt.Component.dispatchEventImpl(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Window.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.run(Unknown Source)
The program saves the Workbooks for smaller files without any problem, but throws the above error for very large files. The file in question is almost 700 pages in length and contains 1409 tables. I’m sorry but I cannot send you the file because it was supplied by our customer and contains confidential information.
Thanks for your help.
Kent
Thank you for sharing your project and exception stack trace with us.
We will further look into your issue and get back to you soon.
Thank You & Best Regards,
Thank you for considering Aspose.
Please try the attached latest version of Aspose.Cells. We have fixed your mentioned issue.
Thank You & Best Regards,
The issues you have found earlier (filed as CELLSJAVA-10352) have been fixed in this update.
This message was posted using Notification2Forum from Downloads module by Aspose Notifier.