Saving of excel

after excelWorkSheet.Cells.ImportDataTable(dataTable, true, “A1”); and saving of excel like below


workbook.Save(HttpContext.Current.Response, fileName, ContentDisposition.Attachment, new OoxmlSaveOptions(SaveFormat.Xlsm)); it taking alot time to save is they any better way to save the excel so that process can be fat

Hi,


Could you simply save the file to disk and check if you still find the performance issue and it is still taking some time to save the file. Also, please add a line to your code for web project i.e. Response.End() if it makes any difference.

If you still find the issue, kindly do create a sample project with v7.5.2 (latest version/fix), zip it and post it here to reproduce the issue on our end, we will check your issue soon.

Thank you.