Hi

Export GridView to Excel in ASP.NET
June 11th, 2011 admin Web Forms 0 Comments


Push data from xml file to GridView:

DataSet ds = new DataSet();

ds.ReadXml(Server.MapPath("Products.xml"));

GridView1.DataSource = ds;

GridView1.DataBind();

Export data from GridView to Excel:

Response.Clear();

Response.AddHeader("content-disposition", "attachment;filename=GridView1.xls");

Response.Charset = "";

Response.ContentType = "application/vnd.xls";

StringWriter StringWriter = new System.IO.StringWriter();

HtmlTextWriter HtmlTextWriter = new HtmlTextWriter(StringWriter);

GridView1.RenderControl(HtmlTextWriter);

Response.Write(StringWriter.ToString());

Response.End();

Complete source code

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.IO;

using System.Data;

 

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

{

    protected void Page_Load(object sender, EventArgs e)

    {

        if (!IsPostBack)

        {

            DataSet ds = new DataSet();

            ds.ReadXml(Server.MapPath("Products.xml"));

            GridView1.DataSource = ds;

            GridView1.DataBind();

        }

    }

    protected void Button1_Click(object sender, EventArgs e)

    {

        Response.Clear();

        Response.AddHeader("content-disposition", "attachment;filename=GridView1.xls");

        Response.Charset = "";

        Response.ContentType = "application/vnd.xls";

        StringWriter StringWriter = new System.IO.StringWriter();

        HtmlTextWriter HtmlTextWriter = new HtmlTextWriter(StringWriter);

        GridView1.RenderControl(HtmlTextWriter);

        Response.Write(StringWriter.ToString());

        Response.End();

    }

 

    public override void VerifyRenderingInServerForm(Control control)

    {

 

    }

}

Example

GridView Data Sheet

ExportGridviewToExcel1 thumb Export GridView to Excel in ASP.NET

Exported Data

ExportGridviewToExcel2 thumb Export GridView to Excel in ASP.NET

Download Source Code
Tags: export gridview to excel in asp net, export gridview to excel, export gridview to excel asp net, how to export gridview to excel in asp net, asp net export gridview to excel, gridview to excel, export to excel in asp net, how to export data from gridview to excel in asp net using c#, code to export gridview to excel in asp net, GridView export to excel