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.
Please use the updated version Aspose.Cells5.1.3.3.zip attached. If the issue persist, please send us a sample application to demonstrate the issue. This will help us to find out the root cause of the issue.
We have replaced the Aspose.Cells.dll with the 5.1.3.3 version. We no longer get the OutOfMemory Exception, but now none of the Excel Worksheets have any data on them. We are using a DataReader as our data input object.
We didn’t change any of the code that was using Aspose Cells, so I am very confused as to why upgrading should cause this problem.