Hi,
I need export over 200k records into an excel.
This process works fine with 50k records:
ExcelEngine excelEngine = new ExcelEngine();
IApplication application = excelEngine.Excel;
application.DefaultVersion = ExcelVersion.Excel2013;
IWorkbook workbook = application.Workbooks.Create(1);
IStyle style = workbook.Styles.Add("RowStyle");
//style.Color = System.Drawing.Color.AliceBlue;
style.Color = System.Drawing.Color.CadetBlue;
style.Font.Bold = true;
IWorksheet sheet = workbook.Worksheets.Create();
sheet.Name = "Nominales";
sheet.SetDefaultRowStyle(1, 1, style);
sheet.ImportData((IEnumerable)lstNominales, 1, 1, true);
workbook.Worksheets.Remove(0);
//workbook.SaveAs(@"c:\datos\datos.xlsx");
workbook.SaveAs("Nominales", page.Response, ExcelDownloadType.PromptDialog, ExcelHttpContentType.Excel2010);
But now, I get this exception.
What can I do?