Export Ajax ControlToolKit lineChart to excel in asp.net

Question

I my application I displayed the linechart using Ajax ControlToolKit then i need to Export linechart to Excel sheet(open office/Libra office). Is it possible to do this? and tell me how can i do this. thank you.

aspx code:

<cc1:LineChart ID="LineChart1" runat="server" ChartHeight="300" ChartWidth="900"
ChartType="Basic" ChartTitleColor="#0E426C" Visible="false" CategoryAxisLineColor="#D08AD9"
ValueAxisLineColor="#D08AD9" BaseLineColor="#A156AB" Style="margin-right: 7px" >
</cc1:LineChart></td></tr></table></center></asp:Panel>

Kk · Answer

thank you for responding, I tried this code but it is not possible to export only grid view data will export.I am using for Ajax Control ToolKit line chart for export to excel using one OnPreRender() but no errors are found but line chart not exporting only gridview will exporting to excel my code is. protected void btnExport_Click(object sender, EventArgs e) { Response.ClearContent(); Response.Buffer = true; Response.AddHeader("content-disposition", string.Format("attachment; filename={0}", "MTTraining-Accuracy.xls")); Response.ContentType = "application/ms-excel"; StringWriter sw = new StringWriter(); HtmlTextWriter htw = new HtmlTextWriter(sw); base.OnPreRender(e); ScriptManager sm = ScriptManager.GetCurrent(Page); sm.RegisterScriptControl(LineChart1); grdMTPerformance.AllowPaging = false; grdMTPerformance.HeaderRow.Style.Add("background-color", "#FFFFFF"); for (int i = 0; i { grdMTPerformance.HeaderRow.Cells[i].Style.Add("background-color", "#df5015"); } LineChart1.Visible = true; LineChart1.RenderControl(htw); grdMTPerformance.RenderControl(htw); Response.Write(sw.ToString()); Response.End(); } protected override void OnPreRender(EventArgs e) { /* Verifies that the control is rendered */ base.OnPreRender(e); ScriptManager scriptManager = ScriptManager.GetCurrent(this.Page); if (scriptManager == null) { this.LineChart1.Visible = true; scriptManager = new ScriptManager(); scriptManager.ID = "ToolkitScriptManager1"; scriptManager.EnablePartialRendering = true; Controls.AddAt(0, scriptManager); } } this is i added code can you tell me how to export this line chart to excel sheet Thank you

Venkat · Answer

Hi ,try html to excel export(with in you can export with image) to create jquery function and try below is reference. function Excelexport() { var export_table= " " ; var textRange; var j=0; var htmltable=document.getElementById( 'headerTable' ); //your html table Id for (j=0;j {export_table=export_table+htmltable.rows[j].innerHTML+ " " ;} export_table=export_table+ " " ; var ua=window.navigator.userAgent; var msie=ua.indexOf( "MSIE" ); //create a iframe and named to frameExport var ourputframe=document.getElementById( 'frameExport' ); if (msie>0||!!navigator.userAgent.match(/Trident.*rv\:11\./)) { ourputframe.document.open( "txt/html" , "replace" ); ourputframe.document.write(tab_text); ourputframe.document.close(); ourputframe.focus(); excelexport=ourputframe.document.execCommand( "SaveAs" , true , "export.xls" ); } else excelexport=window.open( 'data:application/vnd.ms-excel,' +encodeURIComponent(export_table)); return ( excelexport ; }