Export GridView data to excel file in asp.net

Hi.

Here I would like to share a code to export gridview data to excel File. I hope it is useful to understand the concept behind on export grid view data.

When export gridview data you need to use one button to do the action of exporting.

We need to write the code on button event……

 

protected void Button1_Click(object sender, EventArgs e)     {         //***we need to set as paging as false to export all the data from the gridview.         GridView1.AllowPaging = false;         //***Again bind the data into gridview         bindgrid();         //***Function for to export the data...         ExportExcel("File1.xls", GridView1);             }

 Here the method for export excels method function………

public static void ExportExcel(string fileName, GridView gv)     {         HttpContext.Current.Response.Clear();         HttpContext.Current.Response.AddHeader(             "content-disposition", string.Format("attachment; filename={0}", fileName));         HttpContext.Current.Response.ContentType = "application/ms-excel";         using (StringWriter sw = new StringWriter())         {             using (HtmlTextWriter htw = new HtmlTextWriter(sw))             {                 //  Create a form to contain the grid                 Table table = new Table();                                 //  add the header row to the table                 if (gv.HeaderRow != null)                 {                                       table.Rows.Add(gv.HeaderRow);                 }                 //  add each of the data rows to the table                 foreach (GridViewRow row in gv.Rows)                 {                    table.Rows.Add(row);                                     }                 //  add the footer row to the table                 if (gv.FooterRow != null)                 {                                        table.Rows.Add(gv.FooterRow);                 }                 //  render the table into the htmlwriter                 table.RenderControl(htw);                 //  render the htmlwriter into the response                 HttpContext.Current.Response.Write(sw.ToString());                 HttpContext.Current.Response.End();             }         }     }

 Download

I hope you like this article to export the gridview data to excel file ..

Post your comment …