Export Gridview Data to Excel in ASP.Net

In this article, I am going to share the code sample for export gridview data to excel files in ASP.Net using c#.

Table of Contents
1. ASP.Net UI Code sample
2. ASP.Net C# code sample

ASP.Net UI code sample i.e. [.aspx]

  <div style="padding-left:15px;">

      <asp:GridView ID="GrdCollection" runat="server" BackColor="White">               

      </asp:GridView>

  </div>

  <div style="padding-left:15px;">

     <asp:LinkButton ID="lkbExpotExcel" runat="server" OnClick="lkbExpotExcel_Click">Export to Excel</asp:LinkButton>

  </div>

In the above, gridview have the collection of data and have the link button to 'Export to Excel'.

ASP.Net C# code sample i.e. [.aspx.cs]

protected void lkbExpotExcel_Click(object sender, EventArgs e)

{

    Response.Clear();

    Response.AddHeader("content-disposition", "attachment;filename=grdRecordCollection.xls");

    Response.Charset = "";

    Response.ContentType = "application/test.xls";

    StringWriter strWriter = new System.IO.StringWriter();

    HtmlTextWriter strWriterText = new HtmlTextWriter(strWriter);

    GrdCollection.RenderControl(strWriterText );

    Response.Write(strWriter.ToString());

    Response.End();

}