Free Support Forum -

Limitation of no of rows of data which is supported by aspose


<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />what is the maximum no of rows it supports in excel..I have 1900000 rows in the data base but when i save it in excel it shows approx 170000 rows only.

Office excel 2007 supports 1million rows ..

Environment :

IDE : VS2008 With SP1 (.NET Framework 3.5)

Excel Version :Office Excel 2007

Aspose version :

Operating System : Windows 7.0 EnterPrise Eddition (32 bit Operating Sysyem)

This message was posted using Page2Forum from Aspose.Cells for .NET - Documentation

Well, Aspose.Cells supports as many rows as the file (XLS,XLSX, CSV etc. or other) has. The rows limitation is put forth by MS Excel or its specified format. For example, XLS format for Excel 97 - 2003 can have only 65536 rows for a worksheet. Similarly, for XLSX, XLSM and XLSB etc. Excel 2007/2010 formats has maximum of 1048576 rows. Also, if you are filling all the 1 million rows in a single worksheet, it will demand lot of memory (make sure that you have sufficient amount of memory) and the process might take a little more time.

Since you are using some older version of the product, so, we recommend you to try our latest version/fix (e.g v7.0.1.7: Please download attached fix) If you find this issue, create a simple console application, zip it and post it here to show the issue. We will check it soon.

Thank you.