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
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEge1Jlkds6iKKf2CzZnslWt2uUOApkBEb7kM4Ijzqw7DcLiF8iyh5MyHoMx0cLpB8YSoUmGu3YqRp3kuSK_REbiI0uxFxdsfmva3TH7FiKQ2c9S5IVuQeKVJ2Yl47wPLO3poVIdgBTgBdg/s1600/export+gridview+data+to+excel.png)
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();
}