To fetch data from gridview to Excel/Doc

private void Export(GridView GridView1) { System.IO.StringWriter sw = new StringWriter(); System.Web.UI.HtmlTextWriter htw = new HtmlTextWriter(sw); HtmlForm frm = new HtmlForm(); Response.ContentType = "application/vnd.ms-excel" ; Response.AddHeader("content-disposition", "attachment;filename=SomeFile.doc"); Response.Charset = "" ; EnableViewState = false ; Controls.Add(frm) ; frm.Controls.Add(GridView1); frm.RenderControl(htw) ; Response.Write(sw.ToString()) ; Response.End() ; }