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

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://www.code-sample.com and http://www.code-sample.xyz
My Books - Google Amazon and Flipkart Book Store!

You Might Also Like
Post a Comment
www.code-sample.com/. Powered by Blogger.
ASK Questions
SQL Server NodeJs TypeScript JavaScript Angular SQL Server My Book