Exporting Both Data and Excel-Friendly Graphs to Excel

4 posts, 0 answers
  1. Zachary
    Zachary avatar
    2 posts
    Member since:
    Feb 2016

    Posted 11 Feb Link to this post

    Hello,

    Long time reader, first time poster.

    I have been searching the web for reporting to be used in both ASP.NET (preferably using MVC Razor) and supports exporting both the data and the charts/graphs associated with the data into Excel.

     

    So far, the closest I have come is sealreport.org (demo here: http://demo.sealreport.org/temp/Dashboard_-_Sales_t0n4u_htm.htm), but since I have already used Telerik's Kendo solution in the past, I would prefer to leverage your reporting solution.

     

    My asks:

    1. Does Telerik reporting have the ability to export reports to Excel that includes both the data used to create the reports, as well as excel-interactive graphs themselves (see http://demos.telerik.com/reporting/dashboard... it just downloads images. I would add the .XLSX file generated by sealreport, but only images are allowed).

    2. Is it possible to use an HTML5-like styling with the reporting (CSS styling, or something, reactive, etc - my only experience is that it is very structured and limited with what you can do in the designer)?

     

    Please and thank you.

     

    Best,

    ZH

     

     

  2. Stef
    Admin
    Stef avatar
    3041 posts

    Posted 15 Feb Link to this post

    Hello ZH,

    Telerik reports are rendered in a specific format depending on the media they are displayed in, or the format request by an export operation.

    For example, if you use an HTML5 Viewer to display a report, the report will be requested in HTML format. Details how items will be rendered are available in Design Considerations for HTML Rendering. The rendered HTML aims to visualize content as close as possible to the report designed in the report designer. Interactivity like animations are not supported as such features are media specific and cannot be supported in all rendering formats.
    If you are already using Telerik UI for AJAX or Telerik Kendo UI, there are libraries allowing you to export pages in Image, PDF, SVG format. With such approach you can keep the interactivity in browser and get a static document at the end. For more details, please check Exporting HTML From Web App to Image.


    If a report is exported in XLS(X) format, items will be rendered per the Design Considerations for Excel Rendering.  The Excel rendering mechanism is not translating the Graph settings into native Excel chart. Exporting a Graph in Excel will result in a bitmap or EMF inserted in the file.
    I can suggest you to test custom approaches for generating such Excel files e.g. How to create Excel Chart from C# (external blog).


    I hope this information is helpful.

    Regards,
    Stef
    Telerik
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
  3. DevCraft banner
  4. Zachary
    Zachary avatar
    2 posts
    Member since:
    Feb 2016

    Posted 24 Feb in reply to Stef Link to this post

    @Stef,

    Thank you. It sounds like I would need to write my own Excel Export function to include this type of functionality. Is this correct?

    I've actually read that blog post before :-)

    Are there any feature requests related to this for the Telerik team, by chance? I am all about using Telerik solutions, so seeing it get added would be fantastic.

  5. Stef
    Admin
    Stef avatar
    3041 posts

    Posted 26 Feb Link to this post

    Hi Zachary,

    If you want to add custom objects in the Excel file, you can use the already produced Excel file and post-process it e.g. use XLSX format and the DocumentFormat.OpenXML API.
    The processed Graph will be of no use as its elements are not exposed, also the charting mechanism is different than the Excel chart's one. It may be easier to save only data in Excel file, not the report, and then to post-process the Excel file to add more content like Chart objects.

    Please feel free to add requests for such feature in the feedback portal, as features are considered for implementation based on the demand for them.

    Regards,
    Stef
    Telerik
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
Back to Top