We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
Unfortunately, activation email could not send to your email. Please try again.

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

Thread ID:

Created:

Updated:

Platform:

Replies:

123833 Apr 25,2016 11:05 AM Jun 9,2016 05:26 AM ASP.NET Web Forms 12
loading
Tags: XlsIO
Anibal Díaz
Asked On April 25, 2016 11:05 AM

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 [Syncfusion]
Replied On April 26, 2016 02:51 AM

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. 
 
 
Please let us know if you have any concerns. 
 
Regards, 
Abirami. 


Anibal Díaz
Replied On April 26, 2016 03:38 AM

Thanks, works perfect!

Abirami Varadharajan [Syncfusion]
Replied On April 27, 2016 03:22 AM

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
Replied On June 2, 2016 10:54 AM

Hello,

This solution on InternetExplorer11 don't work

Any may help me?

Thanks

Abirami Varadharajan [Syncfusion]
Replied On June 3, 2016 07:00 AM

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.  
  
 
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
Replied On June 3, 2016 08:25 AM

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
Replied On June 6, 2016 04:22 AM

My code example is this...

Attachment: ExcelIE11_1b61db20.rar

Vikas Sekar [Syncfusion]
Replied On June 6, 2016 09:56 AM

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. 
 
 
Please lets us know whether you are facing the same issue in above sample.  
 
Regards, 
Vikas 


Anibal Díaz
Replied On June 6, 2016 10:13 AM

Hello Abirami,

Thanks for you reply.
The issue is same before.
I attach capture of screen.

Regards.

Attachment: Result_9effa9b.rar

Abirami Varadharajan [Syncfusion]
Replied On June 7, 2016 12:03 PM

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. 
 
 
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
Replied On June 8, 2016 04:34 AM

Hello Abirami,

The workaround 1 is fine, thanks!

Best regards.

Abirami Varadharajan [Syncfusion]
Replied On June 9, 2016 05:26 AM

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. 


CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.

;