Failed due to Exception of type 'System.OutOfMemoryException'

Aspose.Cells Product Family
1

generating excel file of size more than 500 MB using aspose.
Getting error of OutofMemoryException.
Compile the code in x64, still it is coming.

Any solution, you guys have.

Thanks,
Sharique

2

@sakhan14,

We were able to observe the issue but we need to look into it more. We have logged the issue in our database for investigation and for a fix. Once, we will have some news for you, we will update you in this topic.

This issue has been logged as

CELLSNET-46285 - System.OutOfMemoryException raised for creating files with size larger than 50 MB

Please note that you may use LightCells API for processing huge files. Visit following link for more details:
Using LightCells API

You may also visit following link to optimize memory usage for large files:
Optimizing Memory Usage

3

@sakhan14,

We evaluated your issue further. For such a large data set and the resultant Excel file, it is sure that lots of memory will be required. We are afraid we cannot make significant improvement for the memory usage for such scenario because the data set does need large amount of memory. If possible you should consider to use LightCells APIs to create such kind of file.