Out of Memory on generating report with millions of rows and hundreds of columns

[carlosdellgarza]

We are trying to generate huge Excel reports but we keep having Out of Memory errors.

Probably it’s not flushing the report partially to the disk as the memory fills up. Is there any way to force it to flush in order to avoid memory problems? Is there a demo anywhere?

Thank you.

[shakeel.faiz]

Hi Carlos,

Thanks for your posting and using Aspose.Cells.

Please use cells.MemorySetting = MemorySetting.MemoryPreference; while generating the workbook with large data sets. We were able to create 1 million rows data without encountering any exception.

Please refer to this thread for sample code and more information on this topic.

( SystemOutOfMemory when using ImportDataTable - large amount of data )

Please also read the following documentation article relating to optimizing memory for large datasets.

• Optimizing Memory Usage while Working with Big Files having Large Datasets