Getting Out of Memory exception when trying to export a file with 125 columns and 2 hundered thousands rows of data

Getting below error while exporting a large file in excel using aspose.

System.OutOfMemoryException: Exception of type ‘System.OutOfMemoryException’ was thrown. at ‰š‹. ›‹. . ›‹.Œ(Int32 ) at ž. ›‹.žŒ(Int32 , Object ) at ‰š‹. ›‹. . ›‹. (Int32 , ™›‹ ) at ‰š‹.Œš‹.‚(Int32 , Boolean , Boolean ) at ‰š‹.”›‹.GetCell(Int32 , Boolean , Boolean ) at Aspose.Cells.Row.GetCell(RowCollection , Int32 , Boolean , Boolean , Boolean ) at Aspose.Cells.RowCollection.GetCell(Int32 , Int32 , Boolean , Boolean , Boolean ) at Aspose.Cells.Cells.ImportObjectArray(Object[] objArray, Int32 firstRow, Int32 firstColumn, Boolean isVertical) at Aon.McLaganLive.QueueTask.Excel.DataExtractor.ExportUsingAspose(List1 listRows, DataTable table, List1 surveyCodeList, String firmName, String fullFilePath) in c:\FusionLive\DEV_2.0\QueueJob Service\Aon.McLaganLive.QueueJobs\Excel\DataExtractor.cs:line 298 at

Hi,


Thanks for providing us some details.

Well, since you are creating or importing a huge data set (i.e., 125 columns and 2 hundred thousands rows) or importing a big object array to the worksheet, so, it would surely consume your resources (RAM, CPU etc.). Also if the file is generated somehow on higher configured machines, it would be a huge one, MS Excel too would take sometime to open into it. Well, you should have a good 64-bit machine with sufficient memory available for the big process. Also, Kindly try our Memory Preference option with our latest version/fix (v16.12.x), see the document for your reference here:

If you still find the issue, kindly do create a simple console application (runnable), zip the project and post us here to reproduce the issue on our end, we will check it soon. Also provide template files (if you have any). Moreover, if you are importing data from some data sources, please create the dataset/datatable(s) dynamically in your code to remove any interdepencies for external data source /database.

Thank you.