Hello,
I am creating an excel spreadsheet from some data. All the part of the code that populates the excel cells works file, but when I'm going to generate the excel file I' m having the error below ( I am using the dll ClosedXML):
Exception of type 'System.OutOfMemoryException' was thrown.
See below the code to generate the excel file (the excel file should have 20 columns and 75500 rows)
Response.Clear();
Response.Buffer = true;
Response.Charset = "";
Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";
Response.AddHeader("content-disposition", "attachment;filename=" + Request["Name"] + "_" + DateNow + ".xlsx ...
Go to the complete details ...