How to Display ASP.NET DataGrid Data in Excel

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/";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();
See also  11 Effective Keyword Research Tools and Techniques

About Our Editorial Process

At DevX, we’re dedicated to tech entrepreneurship. Our team closely follows industry shifts, new products, AI breakthroughs, technology trends, and funding announcements. Articles undergo thorough editing to ensure accuracy and clarity, reflecting DevX’s style and supporting entrepreneurs in the tech sphere.

See our full editorial policy.

About Our Journalist