I have a client project where one of the requests is to export Charts to Excel or powerPoint but with all their data included and NOT as image only. Is any of these two exports achievable with either RadChart or RadHtmlChart? Is it maybe possible to serialise the chart information to Open XML that Office products are able to manipulate? Any recommendations and/or ideas are more than welcome.
Thanks a lot,
Christos
1 Answer, 1 is accepted
RadChart is an image generated by the server and as such can be exported as image only. You can use RadChart.Save() method to save the chart to an image or a memory stream. Then you can use it in any custom scenario. You may as well find this KB article helpful as it demonstrates how to export RadChart to PDF.
The RadHtmlChart renders entirely through JavaScript and thus exporting it even to an image is more complex (and is explained here).
We do not have a framework that exports charts to excel charts as such and for the time being only images/PDFs can be used out of the box (with RadChart). What you can try is to get the data from the code-behind, together with chart properties and build excel charts yourself. Should you succeed in this task and post it as a code library project we will gladly award your efforts with Telerik points.
Marin Bratanov
the Telerik team