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.