Why exception is thrown?
XlsIO.Base uses Response.End method internally for saving a workbook. So when a workbook is saved with HttpResponse, this Response.End method throws ThreadAbortException. You can use a try-catch statement to catch this exception. The Response.End method ends the page execution and shifts the execution to the Application_EndRequest event in the application's event pipeline. The line of code that follows Response.End is not executed.
To over come this problem, SendStream method is used in XlsIO. The following sample code explains it.
Sample to avoid ThreadAbortException
The following C#/VB complete code snippet shows how to avoid exception while saving a file with HttpResponse using XlsIO.
|Article ID:||Published Date:||Last Revised Date:||Platform:||Control:|