Export Gridview Data to Excel in ASP.NET with C#

Export GridView to Excel in ASP.Net with Formatting:

In this Post we try to transfer grid view data to excel by C# code for this we give a very sort and efficient Example of export your data which are display in gridview and datagrid control are exported into excel format in asp.net application.

Examples related to GridView:

Create DataTable for Export gridview to excel:

Now before creating the application, let us create a DataTable with some records for the GridView, the DataTable has the following fields:

Product Id,
Product Name,
Price,
Quantity.

Create DataTable by C# code:

DataTable dt = new DataTable();

dt.Columns.Add("ProductId", typeof(Int32));

dt.Columns.Add("ProductName", typeof(string));

dt.Columns.Add("Price", typeof(string));

dt.Columns.Add("Quantity", typeof(string));

dt.Rows.Add(1, "Lux", "10Rs","10");

dt.Rows.Add(2, "Mobile", "10000Rs","20");

dt.Rows.Add(3, "Sugar", "50/kg","10");

dt.Rows.Add(4, "Biskit", "20Rs","10");

Change the Header Row back to white color:

gvDetails.HeaderRow.Style.Add("background-color", "#FFFFFF");

Export GridView data to excel using ASP.NET and c#:

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="ExportGridviewData.aspx.cs"

Inherits="ExportGridviewData" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<title>Export Gridview Data in to Excel by C#</title>

</head>

<body>

<asp:GridView ID="gvDetails" runat="server" AutoGenerateColumns="false" Height="186px">

<asp:BoundField DataField="ProductId" HeaderText="Product Id" ItemStyle-Width="100">

</asp:BoundField>

<asp:BoundField DataField="ProductName" HeaderText="Product Name" ItemStyle-Width="150">

</asp:BoundField>

<asp:BoundField DataField="Price" HeaderText="Price" ItemStyle-Width="150">

</asp:BoundField>

<asp:BoundField DataField="Quantity" HeaderText="Quantity" ItemStyle-Width="150">

</asp:BoundField>

<%--<asp:BoundField DataField="Quantity" HeaderText="Quantity" ItemStyle-Width="150">

</asp:BoundField>--%>

</Columns>

</asp:GridView>

<br />

<asp:Button ID="Button1" runat="server" Text="Export to Excel" OnClick="btnExport_Click" />

</div>

</form>

</body>

</html>

C# code for convert grid data in t Excel File:

using System;

using System.Data;

using System.IO;

using System.Web.UI;

public partial class ExportGridviewData : System.Web.UI.Page

{

protected void Page_Load(object sender, EventArgs e)

{

if (!IsPostBack)

{

BindGridview();

}

protected void BindGridview()

{

DataTable dt = new DataTable();

dt.Columns.Add("ProductId", typeof(Int32));

dt.Columns.Add("ProductName", typeof(string));

dt.Columns.Add("Price", typeof(string));

dt.Columns.Add("Quantity", typeof(string));

dt.Rows.Add(1, "Lux", "10Rs","10");

dt.Rows.Add(2, "Mobile", "10000Rs","20");

dt.Rows.Add(3, "Sugar", "50/kg","10");

dt.Rows.Add(4, "Biskit", "20Rs","10");

gvDetails.DataSource = dt;

gvDetails.DataBind();

}

public override void VerifyRenderingInServerForm(Control control)

{

/* Verifies that the control is rendered */

}

protected void btnExport_Click(object sender, EventArgs e)

{

Response.ClearContent();

Response.Buffer = true;

Response.AddHeader("content-disposition", string.Format("attachment; filename={0}", "ProductList.xls"));

Response.ContentType = "application/ms-excel";

StringWriter sw = new StringWriter();

HtmlTextWriter htw = new HtmlTextWriter(sw);

gvDetails.AllowPaging = false;

BindGridview();

//Change the Header Row back to white color

gvDetails.HeaderRow.Style.Add("background-color", "#FFFFFF");

//Applying stlye to gridview header cells

for (int i = 0; i < gvDetails.HeaderRow.Cells.Count; i++)

{

gvDetails.HeaderRow.Cells[i].Style.Add("background-color", "#990000");

}

gvDetails.RenderControl(htw);

Response.Write(sw.ToString());

Response.End();

}

Export Gridview Data to Excel

Search This Blog

Tutorials Place