How to export gridview data to excel in asp.net

hi friend!!
its very easy but after very hard work....just paste it with making minute changes..

string s = txtreportname.Text; //textbox for your excel name
Response.Clear();
Response.AddHeader("content-disposition", "attachment;filename=" + s + ".xls");
Response.Charset = "";
Response.ContentType = "application/vnd.xls";
System.IO.StringWriter StringWriter = new System.IO.StringWriter();
HtmlTextWriter HtmlTextWriter = new HtmlTextWriter(StringWriter);
GridView2.RenderControl(HtmlTextWriter);
Response.Write(StringWriter.ToString());
Response.End();
after it just paste this method not matter that it is blank....

public override void VerifyRenderingInServerForm(Control control)
   {

   }

i hope it will help you...

You can see this article, there are 8 solutions, solution five may help you a lot.
9 Solutions to Export Data to Excel for ASP.NET[^]

on aspx page:

<asp:linkbutton id="lnkExporttoExcel" runat="server" causesvalidation="false" cssclass="link" onclientclick="return confirm('Are you sure you want to export this report to excel?');" onclick="OnLnkExportToExcelClick" xmlns:asp="#unknown">Export to Excel</asp:linkbutton>

and on .cs page :

 protected void OnLnkExportToExcelClick(object sender, EventArgs e)
        {
       
 Response.Clear();
                Response.AddHeader("content-disposition", "attachment;filename=CodeProjectExcelHelp_Report.xls");
                Response.Charset = "iso-8859-2";
                Response.ContentType = "application/ms-excel";
               
                using (StringWriter StringWriter = new System.IO.StringWriter())
                {
                    using (HtmlTextWriter HtmlTextWriter = new HtmlTextWriter(StringWriter))
                    {
                        grdUserTaskDetails.AllowPaging = false;//grdUserTaskDetails is my gridview name
                        grdUserTaskDetails.Attributes.AddAttributes(HtmlTextWriter);
                        GetUserTaskDetails();//get your data here
                        MergeRows(grdUserTaskDetails);//formate your repeated rows
                        grdUserTaskDetails.RenderControl(HtmlTextWriter);
                      }
                    string str = "User E-mail Id : " + User.Identity.Name + "<br />" + "Start Date : " + startDate.ToString("dd/MM/yyyy") + "<br /> End Date : " + endDate.ToString("dd/MM/yyyy") + "<br />";
                    Response.Write(str);
                    Response.Write(StringWriter.ToString());
}

public override void VerifyRenderingInServerForm(Control control)
       {
           /* Verifies that a Form control was rendered */
       }

thanks
JMD

Export To Excel[^]
GridView - Export to Excel[^]
Grid View Export To Excel[^]
Export Gridview Contents into Excel[^]
How to export GridView to Excel, render cells, add WordArt, and fill a custom template[^] might help.

..and also have a look on similar answer
export gridview into excel file[^]

search in article u have solution for this...... study it
Export Gridview Data to Excel in ASP.NET[^]
http://www.aspdotnet-suresh.com/2011/04/how-to-export-gridview-data-to-excel-or.html[^]