Export to Excel Functionality in ASP.NET Chart Control

Gohil Jayendrasinh
Jul 04, 2012
48.5k
0
0
Article

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">

</head>

<body>

<div>

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

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

</asp:Series>

</Series>

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

</AxisX>

</AxisY>

</asp:ChartArea>

</ChartAreas>

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

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)