Chart data export to excel or powerPoint

Thread is closed for posting
2 posts, 0 answers
  1. Christos
    Christos avatar
    2 posts
    Member since:
    Oct 2011

    Posted 12 Oct 2012 Link to this post

    Hi All,

    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,

  2. Marin Bratanov
    Marin Bratanov avatar
    3907 posts

    Posted 16 Oct 2012 Link to this post

    Hi Christos,

    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.

    All the best,
    Marin Bratanov
    the Telerik team
    If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to their blog feed now.
Back to Top