Tech
Forums
Jobs
Books
Events
Interviews
Live
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
1
Reply
It Possible export ajax line chart to spreedsheet in asp.net
Kk
Jul 25 2016 9:05 AM
260
Reply
In my application i have ajax control line chart but i need to export that ajax control line chart to excel(open office/Libra office). I tried html table export to excel but line chart is not export. Is It possible to Export ajax ToolKit control line chart to excel can any one help me out and can anyone give me suggestion how to do this.
aspx:
<cc1:LineChart ID="LineChart1" runat="server" ChartHeight="300" ChartWidth="900"
ChartType="Basic" ChartTitleColor="#0E426C" Visible="false" CategoryAxisLineColor="#D08AD9"
ValueAxisLineColor="#D08AD9" BaseLineColor="#A156AB">
</cc1:LineChart>
.cs code:
if (dt.Rows.Count >= 2)
{
string[] x = new string[dt.Rows.Count];
decimal[] y = new decimal[dt.Rows.Count];
for (int i = 0; i < dt.Rows.Count; i++)
{
x[i] = dt.Rows[i][0].ToString();
y[i] = decimal.Parse(dtData2.Rows[i]["Accuracy"].ToString());
}
LineChart1.Series.Add(new AjaxControlToolkit.LineChartSeries { Data = y });
LineChart1.CategoriesAxis = string.Join(", ", x);
LineChart1.ChartTitle = "ABC";
LineChart1.Visible = true;
if (x.Length > 0)
{
LineChart1.ChartWidth = (x.Length * 180).ToString();
}
}
Thakyou
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
1
)
Next Recommended Forum
gridview not working
iis Express keeps pointing to port 8080