Hello Aspose team,
I’m working on a project generating huge Excel files, but legacy softwares deny me to use Light Cells API.
The problem is that I can’t understand why when I generate big reports our JBoss Server takes a lot of memory. I’m importing the data from database directly via a CachedRowSet with the “importResultSet” function of Aspose and then close the resultset to free memory.
Usually the Heap size (12Gb) is not enough to handle the Excel generation. We can’t determine if it is the CachedRowSet who takes this much memory or the Workbook object.
Please help me with this issue.
Thanks and regards