python ruby-programming-language Smalltalk Vue.js Knockoutjs TypeScript JavaScript, OOPs JavaScript Angular 8,7,6,5,4 and 2 Interview Questions and Answers Angular 8,7,6,5,4 and 2 Interview Questions and Answers Angular 4 Angular 2 AngularJs 1.x NodeJs Perl Programming R Programming RequireJs Rust Programming Backbonejs closure programming language go-programming-language kotlin-programming-language
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

Hi there! Welcome to my blog. My name is Anil Singh. I'm a author of this blog. For more detail about me, kindly refer to this link..
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