Export Grid To Excel

Share |

This is simple code to export gridview data in export to excel.

Here I assume that Data table name is “_sampleData” and it is already there. To execute the code I also assumed that button names “Button1” is also present and I have called one function named “GridExportToExcel” on click event of that button.

Following is the function to export Gridview control to excel function has two parameters one is gridview object and name of the excel file. This function generates excel file in “.xls” format.

<br /> <br /> public void GridExportToExcel(GridView gv, string exportedFileName)<br /> {<br /> HttpContext.Current.Response.ClearHeaders();<br /> HttpContext.Current.Response.Clear();<br /> HttpContext.Current.Response.Buffer = true;<br /> HttpContext.Current.Response.AddHeader("content-disposition", "attachment;filename=" + exportedFileName + ".xls");<br /> HttpContext.Current.Response.ContentType = "application/vnd.ms-excel";<br /> HttpContext.Current.Response.Charset = "";<br /> System.IO.StringWriter oStringWriter = new System.IO.StringWriter();<br /> System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);<br /> gv.RenderControl(oHtmlTextWriter);<br /> HttpContext.Current.Response.Write(oStringWriter.ToString());<br /> HttpContext.Current.Response.End();<br /> }<br /> <br />

Download Demo Code here --> ExportToExcelDemo.zip