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">               
  <div style="padding-left:15px;">
     <asp:LinkButton ID="lkbExpotExcel" runat="server" OnClick="lkbExpotExcel_Click">Export to Excel</asp:LinkButton>

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.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 );


Hey! I'm Anil Singh. I author this blog. I'm Active Blogger, Programmer. I love learning new technologies, programming, blogging and participating the forum discussions more...
My Blogs - http://code-sample.com and http://code-sample.xyz
My Books - Interview Questions and Answers Books- Get Your Book in 15+ Digital Stores Worldwide..

You Might Also Like
www.code-sample.com/. Powered by Blogger.
ASK Questions