Out of Memory Exception while Importing data to excel

Aspose.Cells Product Family
1
Hi,

I am trying to create an excel from a data table and while using the worksheet.Cells.ImportDataTable function it gives me Out Of memory exception

2
Hi,

Well, you may try to use MemoryPreference options before importing data or inserting data into the worksheets. Please see the document for your complete reference about the new feature that Aspose.Cells now provides:
http://www.aspose.com/docs/display/cellsnet/Optimizing+Memory+Usage+while+Working+with+Big+Files+having+Large+Datasets

Also, make sure that you got enough memory if you are importing a large DataTable using the APIs.

Let us know if you still find the issue.

Thank you.