I want to generate a xlsx file with 600,000 rows or above, 20 columns in one worksheet. But after the program ran about 20 minutes, the OutOfMemoryError was throwed. The program is attached.
I am using Aspose.Cells 7.0.1 for Java. My CPU is 2.20GHz, and JVM argument setting is "-Xmx1280M".
How much memory does it need? Are there any mistakes in my program? Or is there any optimization to make my program generate the Excel file successfully under the limitation of memory of 1280 MB? Or is there a disk swap mechanism (dump memory to disk and then load it back separately) can be used?
Looking forward for your answer, thanks.