We have a 95.6 MB spreadsheet that gets produced from a Java process whose memory usage jumps by almost a Gigabyte when it enters the section of code that uses Aspose.Cells to write the spreadsheet. To accommodate this large memory requirement of the Aspose.Cells library, we push the memory usage up on the Java VM to a max of 1.5 GB (-Xms256m -Xmx1536m) from our normal limit of 512MB.
Without the VM increase, we get the out of memory exception shown below.
Are there ways to reduce the memory overhead of writing large spreadsheets with Aspose that could reduce our memory requirements? We have tested this process using the latest Aspose library version for Java v8.1.2
Exception in thread "main" java.lang.OutOfMemoryError: Java heap space at
com.aspose.cells.b.a.d.h.a(Unknown Source)
at com.aspose.cells.b.a.d.h.b(Unknown Source)
at com.aspose.cells.b.a.d.h.b(Unknown Source)
at com.aspose.cells.b.a.d.h.a(Unknown Source)
at com.aspose.cells.Ak.a(Unknown Source)
at com.aspose.cells.Ak.a(Unknown Source)
at com.aspose.cells.Ak.a(Unknown Source)
at com.aspose.cells.Ay.a(Unknown Source)
at com.aspose.cells.Ax.a(Unknown Source)
at com.aspose.cells.Ax.b(Unknown Source)
at com.aspose.cells.Ax.a(Unknown Source)
at com.aspose.cells.Workbook.a(Unknown Source)
at com.aspose.cells.Workbook.save(Unknown Source)
at com.aspose.cells.Workbook.save(Unknown Source)