{Property evaluation failed.} when exporting data to excel in vb.net

Monilialtiere

New Member
I am using the code below to export records in a datatable to an excel file using EPPlus. \[code\] Dim excelPackage = New ExcelPackage Dim excelWorksheet = excelPackage.Workbook.Worksheets.Add("DemoPage") excelWorksheet.Cells("A1").LoadFromDataTable(dt, True) Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet" Response.AddHeader("content-disposition", "attachment; filename=ExcelDemo.xlsx") Response.BinaryWrite(excelPackage.GetAsByteArray()) Response.End()\[/code\]However, after walking through the code block, at Response.End(), I get an exception {Property evaluation failed.} Update:
The error log is: \[code\]ERROR: System.Threading.ThreadAbortException: Thread was being aborted. at System.Threading.Thread.AbortInternal() at System.Threading.Thread.Abort(Object stateInfo) at System.Web.HttpResponse.End() at Reporting.Page_Load(Object sender, EventArgs e) in C:\Reporting.aspx.vb:line 38\[/code\]Any idea what could be causing this?
 
Top