Limit of rows

What is the maximum number of rows which Aspose.Cells can read in the below mentioned files?

1- XLS 2003

2- XLS 97

3- XLS 2007 or XLSX

4- HTML

5- CSV

6- Tab delimited


This message was posted using Aspose.Live 2 Forum

Hi,

Well, Aspose.Cells can read 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.

Thank you.

Thanks, but what about the HTML, CSV and tab delimited files?

Hi,

It again depends on MS Excel versions. For example, if Html file is created in Excel97-2003, it will have up to 65536 rows where as in Excel 2007/2010 it will have maximum number or rows same as XLSX/XLSM/XLSB format.

Thank you.