Export to Excel Functionality in ASP.NET Chart Control

</body>

</html>

Step 2: Add an ASP Button control and in its click event call your .cs file as in:

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Data;

using System.IO;

using System.Web.UI.HtmlControls;

using System.Web.UI.DataVisualization.Charting;

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

{

string tmpChartName = "test2.jpg";

protected void Page_Load(object sender, EventArgs e)

{

if (!IsPostBack)

{

CreateChart();

}

}

private void CreateChart()

{
var table = new DataTable();

table.Columns.Add("State", typeof(string));

table.Columns.Add("Education", typeof(long));

table.Columns.Add("Lbl");

var row = table.NewRow();

row["State"] = "Gujarat";

row["Education"] = 791;

table.Rows.Add(row);

row = table.NewRow();

row["State"] = "Delhi";

row["Education"] = 978;

table.Rows.Add(row);

row = table.NewRow();

row["State"] = "Rajasthan";

row["Education"] = 1262;

table.Rows.Add(row);

row = table.NewRow();

row["State"] = "Panjab";

row["Education"] = 1650;

table.Rows.Add(row);

row = table.NewRow();

row["State"] = "Maharastra";

row["Education"] = 2519;

table.Rows.Add(row);

row = table.NewRow();

row["State"] = "Madyapradesh";

row["Education"] = 6071;

table.Rows.Add(row);

Chart1.DataSource = table;

Chart1.DataBind();

string imgPath = HttpContext.Current.Request.PhysicalApplicationPath + tmpChartName;

Chart1.SaveImage(imgPath);

}

So your output is like:



You can see that the .Net chart control creates an image. So we save the chart control as an image.

And call export to Excel.

protected void btnExcel_Click(object sender, EventArgs e)

{

string imgPath2 = Request.Url.GetLeftPart(UriPartial.Authority) + VirtualPathUtility.ToAbsolute("~/" + tmpChartName);

Response.Clear();

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

Response.AddHeader("Content-Disposition", "attachment; filename=test.xlsx;");

StringWriter stringWrite = new StringWriter();

HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite);

string headerTable = @"<Table><tr><td><img src='" + imgPath2 + @"' \></td></tr></Table>";

Response.Write(headerTable);

Response.Write(stringWrite.ToString());

Response.End();

}

}