thread was being aborted error - on save

[Bert Sirkin]

I'm executing the following code once I've created a workbook using XLSIO:

Workbook.SaveAs(sFileName, ExcelSaveType.SaveAsXLS, response, ExcelDownloadType.Open)

where sFileName is the complete path and filename.

This line of code always creates a "thread was being aborted" error. And, when the dialog to open the file appears, the filename is the webpage filename (e.g., mypage.aspx) instead of the filename being supplied.

1. Is there any way to avoid the "thread was being aborted" error?

2. How can I get the OS to use the actual filename that I'm supplying (xxx.xlsx), rather than the webpage name (mypage.aspx) when opening or saving?

[Abirami Varadharajan]

Hi Bert, 

We have invoked Response.End() method inside the Workbook.SaveAs() method to download the Excel file, so the exception occurs sometimes. As this is the known issue in ASP.NET, we have prepared sample to overcome this issue. The sample can be downloaded from following link. 

 

Sample Link: https://www.syncfusion.com/downloads/support/directtrac/general/ze/Sample-1339643824.zip  

 

Please refer to below KB article to overcome this issue at your end. 

 

https://www.syncfusion.com/kb/8443/how-to-overcome-threadabortexception-while-saving-an-excel-file-using-xlsio-base-assembly 

 

References: 

https://support.microsoft.com/en-us/help/312629/prb-threadabortexception-occurs-if-you-use-response-end-response-redir 

https://social.msdn.microsoft.com/Forums/vstudio/en-US/415bb998-8ea4-45b1-ab8f-c7dcdf3506c5/file-download-problem-in-aspnet-c?forum=csharpgeneral 

 

Kindly try and let us know if this helps. 

 

Regards, 

Abirami