Excel with different datasource

2 posts, 0 answers
  1. Kahl
    Kahl avatar
    15 posts
    Member since:
    Nov 2016

    Posted 30 May 2017 Link to this post

    I have a grid (MVC) that displays a summary list, but when I Export to Excel I would like to use a different datasource that has detail information

    when I use the ProxyUrl, it still takes the gridDatasource  and when I use forceProxy(true)  the post api method is called and data is retrieved, but I get the error

    This XML file does not appear to have any style information associated with it. The document tree is shown below.
         

    Currently I am returning a model,   but this seems to need to be some sort of Styling formatting to convert into a excel file to open.

     

    What do I return in the API to allow the List<model> to open in Excel

     

  2. Boyan Dimitrov
    Admin
    Boyan Dimitrov avatar
    2062 posts

    Posted 01 Jun 2017 Link to this post

    Hello,

    I believe that what you are looking for is the Server-side Excel export project. Using server-side code allows the developer full control over the final output.

    Regards,
    Boyan Dimitrov
    Progress Telerik
    Try our brand new, jQuery-free Angular 2 components built from ground-up which deliver the business app essential building blocks - a grid component, data visualization (charts) and form elements.
Back to Top