Error opening the excel file on IE 11

[LokeshLuthra]

We are using aspose to generate excel file. the excel file uses workbook.save() method. something like this

excel.Save(Server.UrlEncode(GetGlobalResourceObject(“ListPage”, “OrganizationList”).ToString()).Replace("+", " ") + “.xls”, SaveType.OpenInExcel, FileFormatType.Default, this.Response);

this works fine, but on IE11 the behavior is not smooth. Some times the excel opens up and sometimes it throws an error as mentioned below

I.e. the file you are trying to open excel , is in a different format than specified by the file extension. Verify that the file is not corrupted and is from a trusted source before opening the file Error While downloading an excel. Would you like to open

Can you please look and advise on this.

Aspose Details -
version - 2.9.7.3
Runtime Version : v1.0.3705

[shakeel.faiz]

Hi,

Thanks for your posting and using Aspose.Cells.

Generally, there are two formats. One is XLS and the other is XLSX.

For XLS, you should use XlsSaveOptions.

For XLSX, you should use OoxmlSaveOptions.

Please check the following code which illustrates how to save your excel file in response stream with correct format.

C#

//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));
}
else
{
workbook.Save(HttpContext.Current.Response, “output.xlsx”, ContentDisposition.Attachment, new OoxmlSaveOptions(SaveFormat.Xlsx));
}

[Amjad_Sahi]

Hi,

Thanks for providing some details.

Well, since you are using some older version (v2.9.7.x) of the product for which we are not sure why you are getting this issue on IE11. We neither check or evaluate your issue with older version that you have We can only recommend you to kindly upgrade to and use newer versions of the product, we have made tremendous enhancements with existing features and incorporated many new/useful features. Please browse our documentation and see the following documents especially on how you may open and save the documents with newer Aspose.Cells APIs:

http://www.aspose.com/docs/display/cellsnet/Opening+Files

http://www.aspose.com/docs/display/cellsnet/Saving+Files

Thank you.