Multiple Grid Export Excel/PDF/CSV

[Roy]

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?

[Atanas Korchev]

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

 

 

[Roy]

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

[Atanas Korchev]

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

 

 

[Roy]

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?

[Atanas Korchev]

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

 

 

[Roy]

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.

[Atanas Korchev]

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

 

 

[Roy]

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.

[T. Tsonev]

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

 

 

[Roy]

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.

[T. Tsonev]

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