Here is my code (.NET C#):
worksheet.Cells.ImportDataTable(ds.Tables, true, “A1”);
workbook.Save(HttpContext.Current.Response, “PoliceActivity.xls”, ContentDisposition.Attachment, new XlsSaveOptions(SaveFormat.Excel97To2003));
The datatable contains 80,000 rows. When the spreadsheet loads, the sheet only contains 60,000 rows. 20,000 rows are being chopped off. Is there a limit on rows that can be added to a worksheet?
I am using version 188.8.131.52