XlsIO SaveAs.(filename, Response, ExcelDownloadType) -> Error.

[Anibal Díaz]

Hello,

I created a workbook with the version property as Excel2007.

When you call the SaveAs method browser (Firefox) sends me a dialog with the Open and Save options.

If I choose the "Save" Excel is saved correctly with the name "filename.xlsx" and looks correctly.

If I choose the "Open" Excel does not open, and change the file extension "filename.xlsx.xls"

Please help.

Thanks!

[Abirami Varadharajan]

Hi Anibal, 

 

We are able to reproduce the issue. We recommend you to set ExcelHttpContentType parameter while saving the workbook to resolve this issue. Kindly refer the below code to achieve this. 

 

Code example: 

 

workbook.SaveAs("Output.xlsx", ExcelSaveType.SaveAsXLS, Response, ExcelDownloadType.Open,ExcelHttpContentType.Excel2013); 

 

 

 

 

We have shared the sample for your reference which can be downloaded from the following link. Kindly refer this and let us know if this helps. 

 

Sample link: http://www.syncfusion.com/downloads/support/directtrac/general/ze/SaveFile-1070218283.zip   

 

Please let us know if you have any concerns. 

 

Regards, 

Abirami. 

[Anibal Díaz]

Thanks, works perfect!

[Abirami Varadharajan]

Hi Anibal, 

  

We are glad to know that the issue has been resolved at your side. Please let us know if you need any further assistance on this. 

  

Regards, 

Abirami. 

[Anibal Díaz]

Hello,

This solution on InternetExplorer11 don't work

Any may help me?

Thanks

[Abirami Varadharajan]

Hi Anibal, 

 

We are unable to reproduce the reported issue from our side. We have shared a screen capture video for your reference which can be downloaded from the following link.  

  

Video link: http://www.syncfusion.com/downloads/support/directtrac/general/ze/123833-577622286.zip  

 

Please share us the issue reproducing sample along with screen capture video and machine culture information which will be helpful for us to provide prompt solution at the earliest. 

 

Please let us know if you have any concerns. 

 

Regards, 

Abirami. 

[Anibal Díaz]

I created a workbook with the version property as Excel2007.

With InternetExplorer11, when I call to SaveAs method, appear dialog with the Open and Save options.

If I choose the "Save" Excel is saved correctly with the name "filename.xlsx" and looks correctly.

If I choose the "Open" Excel does not open, and change the file name and extension to "MyExcelExportPage.aspx"

[Anibal Díaz]

My code example is this...

Attachment: ExcelIE11_1b61db20.rar

[Vikas Sekar]

Hi Anibal, 

 

The reported behavior in downloading excel file in Internet explorer is due to interruption in HttpResponse.End method or Browser customization. We have created very basic sample to illustrate this behavior in below link. 

 

Sample link: http://www.syncfusion.com/downloads/support/directtrac/general/ze/ExcelIE11-781681446  

 

Please lets us know whether you are facing the same issue in above sample.  

 

Regards, 

Vikas 

[Anibal Díaz]

Hello Abirami,

Thanks for you reply.

The issue is same before.

I attach capture of screen.

Regards.

Attachment: Result_9effa9b.rar

[Abirami Varadharajan]

Hi Anibal, 

 

Solution 1: 

 

As a workaround, we have closed the response header in a different way. Please try the below sample and let us know whether the issue is resolved or not. 

 

Sample Link:  http://www.syncfusion.com/downloads/support/directtrac/general/ze/CreateExcel972423622.zip  

 

Note: we have made use Response.Flush() and Close() 

 

Solution 2: 

 

The issue which you are facing is not due to XlsIO control, It is due to interruption in HttpResponse.End() at your browser(As mentioned in our previous update). 

 

We recommend you to reset the Internet Explorer settings and check whether the issue is getting resolved. Kindly follow the below steps for resetting. 

 

1. Close all Internet Explorer and Windows Explorer windows that are currently open.
2. Reopen Internet Explorer.
3. Click the Tools button, and then click Internet options.
4. Click the Advanced tab, and then click Reset.
5. In the Reset Internet Explorer Settings dialog box, click Reset.

 

Please let us know if you have any concerns. 

 

Regards, 

Abirami. 

[Anibal Díaz]

Hello Abirami,

The workaround 1 is fine, thanks!

Best regards.

[Abirami Varadharajan]

Hi Anibal,  

 

Thank you for updating us. 

   

We are glad to know that the issue has been resolved at your side. Please let us know if you need any further assistance on this.  

   

Regards,  

Abirami.