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
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:
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.