The number of rows exceeds the maximum available limit i.e. 1-048-576

Aspose.Cells Product Family
1

Hi,


I am trying to create an excel from a DataTable using the Aspose Cells. But the DataTable has more than 1,048,576 (Maximum number of rows allowed in excel) records and when I try to create the excel it shows only 1,048,576 rows in the excel. Can you please let me know how can I create an excel that can accomodate all the rows from datatable.

Also after creating the excel, I am also converting it to pdf.

Thanks,
Nikhil
2

Hi Nikhil,

Thanks for your posting and using Aspose.Cells.

It is Microsoft Excel XLSX format limitation. You cannot create more than 1048576 rows in Microsoft Excel and therefore Aspose.Cells also cannot create it.

You will have to keep your DataTable less than 1048576 rows or move your rest of rows in separate worksheet(s).

Once, you will split your rows into multiple worksheets, you can then convert them into PDF which will contain all of your rows sequentially. Because when you convert your workbook into PDF format, it first renders first worksheet, then it renders second worksheet, then third and so on. So all of your rows will be displayed sequentially as one set.