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 excelDataGrid_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();
Share the Post:
Share on facebook
Share on twitter
Share on linkedin

Overview

Recent Articles: