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

Free Support Forum - aspose.com

Issue with aspose usage

Hi, Greetings from Arcadix!! Our developer is facing the following issue. Hi, I am using latest trial version of aspose.cells 8.3.1 i have a huge data around 5085 columns and more than 30,000 rows in the DataSet. when we try to save the data in the Excel(xlsx) format, it gives out of memory exception. We will send you the screenshot.

Regards,
Janet


Hi,


Well, since you are inserting huge data list (30000 rows * 5085 cols) which will surely consume your resources and a lot of amount of memory. Make sure that you have sufficient amount of RAM available for the big process. And, when you save the file with that huge data, it would be large sized. Anyways, I think since you have data in the DataSet, so you should try to use ImportDataTable or other respective methods/ options to import the data into the sheet in one go if possible, see the document for your reference on Data Importing options available in Aspose.Cells:
http://www.aspose.com/docs/display/cellsnet/Importing+Data+to+Worksheets

Moreover, you may also try to set Memory preference option while inserting large data set into the sheet, see the document for your reference:
http://www.aspose.com/docs/display/cellsnet/Optimizing+Memory+Usage+while+Working+with+Big+Files+having+Large+Datasets

If you still find the issue, kindly create a sample console application with Aspose.Cells for for NET v8.3.1.x (latest), zip it and post us here to reproduce the issue on our end, we will check it soon.

Thank you.

Hi,

Greeting from Arcadix!!!

Then below solution from them did not work .

Gives Same Out of Memory Exception even if we use Memory preference

I have 5000+ columns and 16000 rows

Which all the the columns have System.String as the data type.

Kindly help us on this.


Regards,

Janet

Hi,


Could you create a sample console application (runnable) with Aspose.Cells for for NET v8.3.2.x (latest), zip it and post us here to reproduce the issue on our end, we will check it soon. Kindly remove database dependency if you have any and create DataSet/ DataTable dynamically in your codes, so we could execute your project to simulate the issue on our end.

By the way, I think you may try using our LightCells APIs. These are mainly designed to read or write cells data one by one without building a complete data model block (using the Cell collection etc. that you use in normal mode) into memory. It works in an event-driven mode. See the document for your reference:
http://www.aspose.com/docs/display/cellsnet/Using+LightCells+API

Thank you.