Facing java.lang.OutOfMemoryError: Java heap space while exporting data in XSLS format

Aspose.Total Product Family
1

Hello All,

I am using trial version of Apose.Cells for exporting data in excel file. But while i have tried to export data in large scale like 100010000 (rowscoloumn) ,it through Out Of memmory error. Anybody please help me that how could I flush those rows which are already written in excel file.

Thanks and Regards
Krishan Gandhi

2

Hi<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

Please increase the available memory of JVM to overcome the memory issue. You may extend the JVM memory appropriately to run your code for creating the big file. Following is the command line if you can make use of it:

java -Xms1000m -Xmx1000m MyTest ......... you may allot more memory appropriately.

Please feel free to contact us if you have any further query. We will be happy to help you out.

Thank You & Best Regards,