Multiple Grid Export Excel/PDF/CSV

12 posts, 0 answers
  1. Roy
    Roy avatar
    30 posts
    Member since:
    Oct 2007

    Posted 20 Nov 2014 Link to this post

    I have a very unique problem here. There are times when I have multiple UI MVC Grids on a page. And the new export to excel works great for it. But what I need to be able to do is export 1 or more grids on the page to a single PDF and in the Excel export each grid to a tab in the excel document. Is there a way to do this?
  2. Atanas Korchev
    Admin
    Atanas Korchev avatar
    8462 posts

    Posted 24 Nov 2014 Link to this post

    Hello Roy,

    Please check this how to help article which shows how to export multiple grids to excel: http://docs.telerik.com/kendo-ui/web/grid/how-to/excel/multiple-grid-export

    You can export the DOM element that contains your grid. Here is an example which shows how: http://demos.telerik.com/kendo-ui/drawing/export

    Regards,
    Atanas Korchev
    Telerik
     

    Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.

     
  3. Roy
    Roy avatar
    30 posts
    Member since:
    Oct 2007

    Posted 26 Nov 2014 in reply to Atanas Korchev Link to this post

    That was a great help, I do have one question though, will this export all rows all pages of the grids, or do you have to do something different to make make sure all rows from all pages are exported to an excel or pdf
  4. Atanas Korchev
    Admin
    Atanas Korchev avatar
    8462 posts

    Posted 28 Nov 2014 Link to this post

    Hello Roy,

    Please check this help article: http://docs.telerik.com/kendo-ui/aspnet-mvc/helpers/grid/excel-export#export-all-data

    Regards,
    Atanas Korchev
    Telerik
     

    Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.

     
  5. Roy
    Roy avatar
    30 posts
    Member since:
    Oct 2007

    Posted 15 Dec 2014 in reply to Atanas Korchev Link to this post

    The example of grid export of multiple grids to Excel is great,is there an example of doing the same thing but with PDF's?
  6. Atanas Korchev
    Admin
    Atanas Korchev avatar
    8462 posts

    Posted 16 Dec 2014 Link to this post

    Hello Roy,

    PDF export can work on arbitrary DOM element. Here is a demo which shows how to export multiple Kendo UI widgets: http://demos.telerik.com/kendo-ui/drawing/export

    Regards,
    Atanas Korchev
    Telerik
     

    Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.

     
  7. Roy
    Roy avatar
    30 posts
    Member since:
    Oct 2007

    Posted 16 Dec 2014 in reply to Atanas Korchev Link to this post

    I did see that demo, the only thing wrong with that demo, is it does not grab all of the rows from all of the pages from the grid. Is there a way to get all of the rows for the grid before the PDF is created.
  8. Atanas Korchev
    Admin
    Atanas Korchev avatar
    8462 posts

    Posted 18 Dec 2014 Link to this post

    Hello Roy,

    Exporting all pages from the grid is something that we're working on, but its not supported out of the box.

    I'm attaching a demo based on our latest internal builds that does that.
    You'll see each page as its being exported. This is something that we're looking forward to improve by making it a built-in feature.

    Regards,
    Atanas Korchev
    Telerik
     

    Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.

     
  9. Roy
    Roy avatar
    30 posts
    Member since:
    Oct 2007

    Posted 18 Dec 2014 in reply to Atanas Korchev Link to this post

    Okay this looks cool. Just one comment, it runs but the PDF is never generated. How would one do multiple grids to one PDF with all the rows, would this involve using promises., if so could you also use a promise with say two grids getting all the rows and a chart also.
  10. T. Tsonev
    Admin
    T. Tsonev avatar
    2831 posts

    Posted 19 Dec 2014 Link to this post

    Hi,

    I've tested the demo and it seems to work. There might be a problem if you're loading the demo from the file system.
    Does it work if you host it in a web server?

    Regards,
    T. Tsonev
    Telerik
     

    Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.

     
  11. Roy
    Roy avatar
    30 posts
    Member since:
    Oct 2007

    Posted 19 Dec 2014 in reply to T. Tsonev Link to this post

    Yes I was using as file system, after I converted it to a website it did work. Just a suggestion if you plan to implement this as function on the grid, it would be nice if it was behind the scene and a way to use templates for every portion (header, body and footer) so one does not see the pages footer and that one does not have to see it scroll trough each page on the screen.
  12. T. Tsonev
    Admin
    T. Tsonev avatar
    2831 posts

    Posted 23 Dec 2014 Link to this post

    Hello,

    If I understand correctly, you'd like the header to be visible only on the first page. Same for the footer, but on the last page.
    This makes sense and we can expose it as an option for the PDF export.

    Regards,
    T. Tsonev
    Telerik
     

    Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.

     
Back to Top