My user request to have excels files with hudge amount of data (over 200.000 rows and 40 columns).
Data I receive directly from data base using iDB2DataReader.
To create aspose workbook I use below code:
Workbook wbook = new Workbook();
Worksheet sheet = wbook.Worksheets;
sheet.Cells.ImportDataReader(dr, true, 0, 0, false,“yyyy-MM-dd”,false);
But I have problem becouse in excel file data are cut (in one excel sheet is only 64k rows - excel restictions). I know that in newest excel (*.xslt) this restriction does not exists, but user must have files in old excel format.
Is there any method to create in excel file many workseets each with 64k rows to have all data?