Memory Problem Worksheet.Cell.InsertDataTable

Aspose.Cells Product Family
1

Dear I am inserting data into different sheets, and when you reach the third page I encounter this problem ‘System.OutOfMemoryException’, not how to solve it.

In advance thank you very much

2

Hi,

Thanks for your posting and using Aspose.Cells for .NET.

Please download and try the latest version:
Aspose.Cells
for .NET v7.1.0.5
and let us know if it works fine for you.

3

Dear thank you very much, I do not re-appear at the problem, but if I have one last question, what is the maximum number of records that I can export my excel template with this tool? .

Attentive to your comments
Esteban

4
Hi,

Regarding maximum number of records/rows, this limitation is concerned with MS Excel for XLS and XLSX formats and it depends on the format type. Aspose.Cells does not put forth any limitation but follows MS Excel Standards.

e.g
For XLS (Excel 97- 2003) --> you can have 65536 rows and 256 columns in a worksheet
For XLSX or other Excel 2007/2010 formats, you may have 1048576 rows and lots of columns in a single worksheet.
And, you can add/have as many worksheet as you like (it depends upon your resources) in a single workbook Excel file.

Thank you.