We have been trying to deal with a problem we have been having with Generating Excel Worksheets from our SQL Database.
Situation: A number of reports are queued and picked up by the Report Generator. A new Workbook is created and each Report is added as a new sheet in the Workbook. Some of the reports generate without errors, while other reports throw the OutOfMemory Exception. The errors do not cascade over reports, so reports after an errored report may or may not throw an OutOfMemory Exception. Using basic Memory Profilers we have found that the Report Generator App is using, at most, about 1.5GB of Memory, which is well under the 2GB limit for 32-bit applications.
We are using Aspose.Cells version 4.7.1.12.
Thanks,
Justin