how to reduce time to export excel in c#

hello all ,

i need to reduce execution time to export excel in c#. i have dataset and i am writing in excel file using closedxml
.it taking 45 seconds.. i measured time using stop watch..how can i reduce time to 3 to 5 seconds from 45 seconds.

i am attaching code snap please review my code where i can optimise my code to reduce execution time.

this is my code where i am adding dataset ... it is taking time ....please help where i can optimise .
thanx in advanced.

Hi Amita,

Try this code:

public string Export(List<string[]> exceldataList, string fileName)
{
ExcelPackage.LicenseContext = LicenseContext.NonCommercial;
using (ExcelPackage excel = new ExcelPackage())
{
excel.Workbook.Worksheets.Add("Sheet1");
var worksheet = excel.Workbook.Worksheets["Sheet1"];
worksheet.Cells[1, 1].LoadFromArrays(exceldataList);
excel.Workbook.Properties.Title = "Attempts";
int ColCount = worksheet.Dimension.Columns;
for(int i = 2; i <= ColCount; i++)
{
worksheet.Column(i).AutoFit();
}
this.Response.Clear();
this.Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";
this.Response.AddHeader(
"content-disposition",
string.Format("attachment; filename={0}", fileName));
this.Response.BinaryWrite(excel.GetAsByteArray());
this.Response.End();
}
return "";
}

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Mageshwaran R5y ago
Hi Amita,

Try this code:
public string Export(List<string[]> exceldataList, string fileName)
      {

              ExcelPackage.LicenseContext = LicenseContext.NonCommercial;
              using (ExcelPackage excel = new ExcelPackage())
              {
                  excel.Workbook.Worksheets.Add("Sheet1");
                  var worksheet = excel.Workbook.Worksheets["Sheet1"];
                  worksheet.Cells[1, 1].LoadFromArrays(exceldataList);
                  excel.Workbook.Properties.Title = "Attempts";
                  int ColCount = worksheet.Dimension.Columns;
                  for(int i = 2; i <= ColCount; i++)
                  {
                      worksheet.Column(i).AutoFit();
                  }
                  this.Response.Clear();
                  this.Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";
                  this.Response.AddHeader(
                            "content-disposition",
                            string.Format("attachment;  filename={0}", fileName));
                  this.Response.BinaryWrite(excel.GetAsByteArray());
                  this.Response.End();
              }

          return "";
      }