Free Support Forum - aspose.com

Aspose.Cells v4.2 - Maximum Number of Rows for Excel File

Can someone at Aspose tell me

1) the maximum number of rows that Aspose.Cells v4.2+ for .NET can write to an Excel File.

2) whether i would need the latest version of Excel (2007) to open a file with more that 65K rows

I am looking for a definitive answer on the above two questions.

I know there are work arounds such using multiple worksheets to write rows of data once i get close to 65K, 130K etc so i end up with ~65K, ~65K etc

Hi,

Thanks for considering Aspose.

1). Aspose.Cells for .Net version 4.2 supports .xls file format (MS Excel 97 - MS Excel 2003). and these MS Excel versions only allow 256 cols with 65536 rows in a worksheet although you may have as many worksheets as you want in a workbook.

2). Our latest version Aspose.Cells for .Net 4.4. does support .xlsx file format additionally (i.e., MS Excel 2007 Xlsx). MS Excel 2007 embeds to have approx. 16384 cols with 1048576 rows and our latest version supports this functionality.

Thank you.