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