Please use this code to save your file in XLS or in XLSX format in Response stream.
//Save file and send to client browser using selected format
if (yourFileFormat == “XLS”)
workbook.Save(HttpContext.Current.Response, “output.xls”, ContentDisposition.Attachment, new XlsSaveOptions(SaveFormat.Excel97To2003));
workbook.Save(HttpContext.Current.Response, “output.xlsx”, ContentDisposition.Attachment, new OoxmlSaveOptions(SaveFormat.Xlsx));
Thanks for your quick response. However, there are no overloads available which accept a HTTPResponse. I am using the 188.8.131.52 version of Aspose.Cells. I am using .Net framework 3.5 and the component description is ‘Aspose.cells for .Net Frame Client Profile’ if that helps
Please make sure, you are using the right dll.
Please use the DLL under the directory “net2.0” and not “net3.5_ClientProfile”.
And please check the readme.txt under the directory
Please see this image for more help.
Thanks, that worked