We have Aspose 4.8.2.0. We are trying to write excel file from DB using excel services. While doing that the transfer disconnects after 3960th row. Is there any limit on the maximum rows in this version fo Aspose? Do we need a upgrade? I appreciate your help in this regard.
Hi,
Well, Aspose.Cells can 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.
Shakeel,
Thanks for the response. can you guess what might be the problem?
-ANB