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. (Last updated on : Nov 16th 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

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

Thread ID:

Created:

Updated:

Platform:

Replies:

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

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 06:51 AM UTC

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 07:38 AM UTC

Thanks, works perfect!

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

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 02:54 PM UTC

Hello,

This solution on InternetExplorer11 don't work

Any may help me?

Thanks

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

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 12:25 PM UTC

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 08:22 AM UTC

My code example is this...

Attachment: ExcelIE11_1b61db20.rar

Vikas Sekar [Syncfusion]
Replied On June 6, 2016 01:56 PM UTC

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 02:13 PM UTC

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 04:03 PM UTC

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 08:34 AM UTC

Hello Abirami,

The workaround 1 is fine, thanks!

Best regards.

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

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.

Warning Icon 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.Close Icon

;