Exporting data to XL

[Bill Humphrey]

Hi

How can I export data from in a data grid to XL or word. I found this code but it just opens a blank XL sheet:



Response.Clear()
Response.AddHeader("content-disposition", "attachment;filename=FileName.xls")
Response.Charset = ""
Response.Cache.SetCacheability(HttpCacheability.NoCache)
Response.ContentType = "application/vnd.xls"
Dim stringWrite As new System.IO.StringWriter()
Dim htmlWrite As new HtmlTextWriter(stringWrite)
myDataGrid.RenderControl(htmlWrite)
Response.Write(stringWrite.ToString())
Response.End();



Regards Bill

 

[MattP]

This would be a good place to start:

Erika Ehrli : How to Export Data to Excel from an ASP.NET Application + Avoid the File Format Differ Prompt