License for Aspose.Cells for .NET

Aspose.Cells Product Family
1

Hi,

I downloaded the Aspose.Cells 4.7.0.0 from aspose.com. I am trying to use this control to generate large excel files. But it threw out of memory exception.



I am using ImportFromDataReader method on the Cells Class.I have about 4 million rows in the result set. How can I create an excel file without running out of memory?

If this is a support question, could you forward it to them?

Thanks

Suganthi

This message was posted using Email2Forum by sheliah.
2

Hi,

Thank you for considering Aspose.

Well, 4 million rows are too much for an Excel file. For an Excel97-Excel2003 file, the limit of rows in a worksheet is 64K. For an Excel2007 file, the limit is 1 million rows. So, you have to split the result set into several worksheets. However, if you can create an Excel file with 4 million rows, it will be very huge. Based on our estimation, the file size of a 4 million rows and 10 columns Excel file will be larger than 900MB. To create such a file, I think it needs at least 9GB memory to create such a file.

So our suggestion is to split your result set to create number of smaller Excel files.

Thank You & Best Regards,