I have some code that creates and writes to an excel file.  Right as I
response.end() to avoid HTML in the Excel document, I get an exception:

---------------

An attempt to log the following error
failed:System.Threading.ThreadAbortException: Thread was being aborted.
at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()

-----------------

Here's my code

Public Sub btnShasExcel_OnClick(ByVal sender As System.Object, ByVal e As
System.EventArgs)

Try
   Dim ds As New DataSet
   Dim da As New SqlDataAdapter(Session("savedShasSql"),
connection1.conString)
   da.Fill(ds, "ShasExcel")
   Dim dt As DataTable = ds.Tables("ShasExcel")

'This code was dumping html into the spreadsheet
   'Response.ContentType = "application/ms-excel"
   'Response.AddHeader("Content-Disposition", "inline;filename=shas.xls")
   'Response.Write(ConvertDtToTDF(dt))

'This is the new code
   Response.ContentType = "application/ms-excel"
   Response.AddHeader("Content-Disposition", "inline;filename=shas.xls")
   Response.Clear()
   Response.Write(ConvertDtToTDF(dt))
   Response.End()

Catch ex As Exception
   ExceptionManager.Publish(ex)
End Try

End Sub

Private Function ConvertDtToTDF(ByVal dt As DataTable) As String

Try

Dim dr As DataRow, ary() As Object, i As Integer
   Dim iCol As Integer

   'Output Column Headers
   For iCol = 0 To dt.Columns.Count - 1
       Response.Write(dt.Columns(iCol).ToString & vbTab)
   Next

   Response.Write(vbCrLf)

   'Output Data

       For Each dr In dt.Rows
           ary = dr.ItemArray
           For i = 0 To UBound(ary)
               Response.Write(ary(i).ToString & vbTab)
           Next
       Response.Write(vbCrLf)
       Next

Catch ex As Exception
   ExceptionManager.Publish(ex)

End Try

End Function

_____
DC G