Export Gridview Data to Excel in ASP.Net

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();
}



ANIL SINGH

Anil Singh is an author, tech blogger, and software programmer. Book writing, tech blogging is something do extra and Anil love doing it. For more detail, kindly refer to this link..

My Tech Blog - https://www.code-sample.com/
My Books - Book 1 and Book 2

Export Gridview Data to Excel in ASP.Net Export Gridview Data to Excel in ASP.Net Reviewed by Unknown on 11:47 PM Rating: (5)
www.code-sample.com/. Powered by Blogger.
^