Export Data from a ASP.NET datagrid to Microsoft Excel
Following Code will help you to export a datagrid control contents to MS excel Spreadsheet 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(DivDetails);DataGrid1.ForeColor = System.Drawing.Color.Black;DataGrid1.RenderControl(oHtmlTextWriter);Response.Write(oStringWriter.ToString());Response.End();
