Workbook object exceeds Heap size limit

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

@framad,

Thanks for your query.

This issue requires thorough investigation therefore your assistance is required. Please prepare some console application(runnable) with hard coded data as alternative to the database. We need to re-produce this scenario here to observe the issue and provide our feedback after analysis.