I tried the feature for Saving a newly generated Excel fly using the save to Response Object, however it doesnt work for correctly files saved as xlxs file format.
The file generated is a corrupted file and cant be opend up by excel.
Please call Response.End(); after calling Workbook.Save("Report_New.xlsx", FileFormatType.Excel2007Xlsx, SaveType.OpenInExcel, Response); Also, kindly make sure that these lines should be the last lines for your procedures/methods.