when we try to import directly from datareader over 1,048,576 rows to xlsx (excel) file the data are cut to 1,048,576 - maximum row limit for excel sheet.
Workbook wbook = new Workbook();
Worksheet sheet = wbook.Worksheets;
sheet.Cells.ImportDataReader(dr, true, 0, 0, false,“yyyy-MM-dd”,false);
Is any method to split data into more than one sheet during import from datareader (not from datatable)? In this case excel is not going to cut data to 1,048,576 rows.
Thanks for help.