How to Display ASP.NET DataGrid Data in Excel

Suppose you have a DataGrid with several columns full of data. The DataGrid contains several pages. You can disable paging and export all the data to Excel using the RenderControl method:


//export to excel
DataGrid_Dimension.AllowPaging = false;
BindGrid();

Response.Clear();
Response.Buffer= true;
Response.ContentType = "application/vnd.ms-excel";
Response.Charset = "";
this.EnableViewState = false;

System.IO.StringWriter oStringWriter = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter oHtmlTextWriter = 
   new System.Web.UI.HtmlTextWriter(oStringWriter);

this.ClearControls(DataGrid_Dimension);
DataGrid_Dimension.RenderControl(oHtmlTextWriter);

Response.Write(oStringWriter.ToString());

Response.End();

Naveen Lanke

Submit a Tip

Browse "Java" Tips

Browse All Tips

0 Comments (click to add your comment)

Comment and Contribute