In my previous blog you learned how to create a chart in ASP.NET.

In Business Application reporting functionality is important. So in this blog I describe how to export to Excel from an ASP.NET Chart control.

Step 1: Create a chart control.

First follow all the steps of my previous article "How to Create Chart in ASP.NET":

http://www.c-sharpcorner.com/Blogs/8620/how-to-create-chart-in-Asp-Net.aspx

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>

<%@ Register Assembly="System.Web.DataVisualization, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"

Namespace="System.Web.UI.DataVisualization.Charting" TagPrefix="asp" %>

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

<html xmlns="http://www.w3.org/1999/xhtml">

<head runat="server">

<title></title>

</head>

<body>

<form id="form1" runat="server">

<div>

<asp:Chart ID="Chart1" runat="server" Width="500px">

<Series>

<asp:Series Name="Education" XValueMember="State" YValueMembers="Education" IsVisibleInLegend="true">

</asp:Series>

</Series>

<ChartAreas>

<asp:ChartArea Name="ChartArea1" Area3DStyle-Enable3D="false">

<AxisX LineColor="DarkGray">

<MajorGrid LineColor="LightGray" />

</AxisX>

<AxisY LineColor="DarkGray">

<MajorGrid LineColor="LightGray" />

</AxisY>

<Area3DStyle Enable3D="false"></Area3DStyle>

</asp:ChartArea>

</ChartAreas>

<Legends>

<asp:Legend>

</asp:Legend>

</Legends>

</asp:Chart>

</div>

<div>

<asp:Button ID="btnExcel" runat="server" Text="Export To Excel" OnClick="btnExcel_Click" />

</div>

</form>

</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:

ExprtExcl.jpg

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();

}

}