Can I have more than 1,048,576 rows when exporting to a text file?

[M2Tech]

Hello,
I know excel has a limitation of 1,048,576 rows when dealing with xlsx files. I understand Aspose.Cells has the same limit when reading/writing to this file type. I wanted to know why that same limit exists when I am trying to save the workbook as either a CSV or Tab Delimited text file and if there is anyway around it?

I was hoping that when a create a new Workbook passing it a FileFormatType of CSV or Tab that this limitation would be lifted.

Any help you can provide would be great.

Take care,
Ken

[Amjad_Sahi]

@M2Tech,

Thanks for your query.

Well, this is the limitation of MS Excel (2007 - 2013/2016) file formats (XLSX or others (including CSV) etc.). MS Excel only allows you to have a maximum of 1048576 rows for a worksheet (you cannot save/load more data than this limitation), so you cannot cross this limit. Aspose.Cells follows MS Excel standards and specifications and cannot go beyond it. You can confirm this limitation by opening a new Workbook/file into Ms Excel (2007/2010 or 2013/2016) or even open a template CSV/Tab Delimited file and check the last row index.

Thank you.