Export datagrid to excel

[Ed Chiu]

Hi,

I copied the following codes from Internet to export datagrid to Excel, it
works with datagrid not supporting sorting or paging.

Response.Conten tType = "applicatio n/vnd.ms-excel"
Response.Charse t = ""
Response.AddHea der("Content-Disposition", "attachment;fil ename=Statement .xls")
Me.EnableViewSt ate = False

Dim tw As New System.IO.Strin gWriter
Dim hw As New System.Web.UI.H tmlTextWriter(t w)
DataGrid1.Rende rControl(hw)
Response.Write( "<table><tr><td ><b>" + lblMessage.Text +
"</b></td></tr><tr><td>" + tw.ToString() + "</td></tr></table>")
Response.End()

Looks like if datagrid supports sorting or paging, ASP.Net will render HTML
with Javascript inside, and the codes here do not like that. Is there a
workaround?

TIA

[Steve C. Orr [MVP, MCSD]]

You should disable datagrid paging when exporting to Excel. In that case
just write out all the records in one long page because this is how Excel
likes to deal with data. Excel doesn't do JavaScript.

Here's more info:
http://www.SteveOrr.net/articles/ExcelExport.aspx
http://www.SteveOrr.net/articles/ExportPanel.aspx

--
I hope this helps,
Steve C. Orr, MCSD, MVP
http://SteveOrr.net
"Ed Chiu" <Ed****@discuss ions.microsoft. com> wrote in message
news:65******** *************** ***********@mic rosoft.com...

Hi,

I copied the following codes from Internet to export datagrid to Excel, it
works with datagrid not supporting sorting or paging.

Response.Conten tType = "applicatio n/vnd.ms-excel"
Response.Charse t = ""
Response.AddHea der("Content-Disposition",
"attachment;fil ename=Statement .xls")
Me.EnableViewSt ate = False

Dim tw As New System.IO.Strin gWriter
Dim hw As New System.Web.UI.H tmlTextWriter(t w)
DataGrid1.Rende rControl(hw)
Response.Write( "<table><tr><td ><b>" + lblMessage.Text +
"</b></td></tr><tr><td>" + tw.ToString() + "</td></tr></table>")
Response.End()

Looks like if datagrid supports sorting or paging, ASP.Net will render
HTML
with Javascript inside, and the codes here do not like that. Is there a
workaround?

TIA