This is a migrated thread and some comments may be shown as answers.

Multiple Grid Export Excel/PDF/CSV

11 Answers 355 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Roy
Top achievements
Rank 1
Roy asked on 20 Nov 2014, 05:46 PM
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?

11 Answers, 1 is accepted

Sort by
0
Atanas Korchev
Telerik team
answered on 24 Nov 2014, 02:04 PM
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.

 
0
Roy
Top achievements
Rank 1
answered on 26 Nov 2014, 08:53 AM
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
0
Atanas Korchev
Telerik team
answered on 28 Nov 2014, 07:38 AM
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.

 
0
Roy
Top achievements
Rank 1
answered on 15 Dec 2014, 08:37 AM
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?
0
Atanas Korchev
Telerik team
answered on 16 Dec 2014, 08:44 AM
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.

 
0
Roy
Top achievements
Rank 1
answered on 16 Dec 2014, 07:57 PM
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.
0
Atanas Korchev
Telerik team
answered on 18 Dec 2014, 09:54 AM
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.

 
0
Roy
Top achievements
Rank 1
answered on 18 Dec 2014, 06:35 PM
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.
0
T. Tsonev
Telerik team
answered on 19 Dec 2014, 02:10 PM
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.

 
0
Roy
Top achievements
Rank 1
answered on 19 Dec 2014, 06:48 PM
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.
0
T. Tsonev
Telerik team
answered on 23 Dec 2014, 09:26 AM
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.

 
Tags
Grid
Asked by
Roy
Top achievements
Rank 1
Answers by
Atanas Korchev
Telerik team
Roy
Top achievements
Rank 1
T. Tsonev
Telerik team
Share this question
or