HI I am using Aspose Cells for Java and trying to export to CSV.
and am trying to export 1.5 million rows.
csv export is being used for data dump in our app and I am getting a error “Invalid row index”
I want to confirm that the row limit is getting limited by the fact that the Workbook object although being used for export to csv can hold only excel2017 row limit.
If I wish to export more than 1.5 million rows have to use something different - if you could say anything else within the aspose suite.
We are using Aspose Enterprise Edition - Aspose Total for Java 8.1.2 version
Workbook CSVWB = new Workbook();
Worksheet CSVsheet = CSVWB.getWorksheets().get(0);
Cells cell = CSVsheet.getCells();
TxtSaveOptions opts = new TxtSaveOptions(SaveFormat.CSV);
/**AFTER ABOUT 1048576 rows then it throws Invalid row index and errors/
NOTE: after 1048576 should I be creating another sheet and starting from the start. Will it put my data properly one after the other. My real code is a multi column output.