We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Out of Memory Exception while Importing data to excel

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


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.