Aspose.Cells for .NET Site Small Business License

Hello,
One of our clients has a request on Aspose.Cells for .NET Site Small Business License. But end user wants to know if there is limitation on number of rows in excel.
Please help to confirm it.

@xlsoftchina1,

Thanks for your query.

No, there is no such limitation enforced by Aspose.Cells APIs. Aspose.Cells follows MS Excel standards and specifications. Number of rows and columns also dependent upon which MS Excel file format (XLS, XLSX, etc.) you are using. For your information, using XLS (MS Excel 97 - 2003) file format, you can only have 65536 rows and 265 columns in a worksheet. With XLSX file format which is an advanced file format (MS Excel 2007 - 2013/2016). you can have 1048576 rows and 16384 columns in a single worksheet.
FYI:
XLS
65536x256 (till column IV)

XLSX/XLSM/XLSB, etc.
1048576x16384 (till column XFD)

Let us know if we can be of any further help.

Hello, actually it depends, but usually, no, there isn’t a limitation on the number of rows in excel.

@tabeeR,

Is there anything we can help you with? Please elaborate and share more details about your issue, so we could understand you and help you better.

Hi, There is no limitation on the rows in excel.

@JeanetteMMitchell,

Yes, there is no such limitation enforced by Aspose.Cells APIs regarding number of rows in Excel spreadsheet. Aspose.Cells follows MS Excel standards and specifications. Number of rows and columns also dependent upon which MS Excel file format (XLS, XLSX, etc.) you are using. For your information, using XLS (MS Excel 97 - 2003) file format, you can only have 65536 rows and 265 columns in a worksheet. With XLSX file format which is an advanced file format (MS Excel 2007 - 2013/2016). you can have 1048576 rows and 16384 columns in a single worksheet.
FYI:
XLS
65536x256 (till column IV)

XLSX/XLSM/XLSB, etc.
1048576x16384 (till column XFD)

Let us know if we can be of any further help.