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

Multiple GridView export to single file (pdf/xlsx)

4 Answers 118 Views
GridView
This is a migrated thread and some comments may be shown as answers.
guobian
Top achievements
Rank 1
guobian asked on 08 Dec 2015, 10:31 PM

Hi there, 

I have found that it is possible to export multiple GridViews into single Excel file via GridViewSpreadExport  in Winform forum. 

I wonder if this can be achieved in the UI for WPF libraries.

My objects is to export multiple grids into a single file, preferable both in PDF and XLSX. 

Many thanks, 

 

 

4 Answers, 1 is accepted

Sort by
0
Petya
Telerik team
answered on 11 Dec 2015, 03:49 PM
Hi,

In the Q1 2016 release that will be out in about a month, we're going to introduce some methods that will make exporting several RadGridView instances into a single workbook pretty straight-forward. We're also planning on creating an example in our SDK repository targeting at this specific scenario, so I hope the time frame suits you.

As far as PDF format is concerned, what I presume you're after is to export the different grid controls on separate sheets in the XLSX file. While our RadSpreadProcessing library provides XLSX to PDF conversion, this only works for the active sheet in the workbook, meaning a PDF document cannot be composed by the contents of several sheets. One thing that comes to mind is that if each RadGridView is exported to a separate RadFixedDocument instance, you could merge them together. I'm attaching to my reply a sample showing how this can be achieved by utilizing the ExportToPdf method, I hope it helps.

Regards,
Petya
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
0
guobian
Top achievements
Rank 1
answered on 14 Dec 2015, 02:39 PM

Hi Petya, 

I am looking forward to use Q1 2016 library although it does fit my timeline scale. I will use alternative approach for the time being. 

Actually, I would like to see two export methods for XLSX format. E.g.: one to export in different sheets like RadSpreadProcess does, and alternative to export all grids in one sheet.

As for the PDF format, you provided demo is what I after. E.g.: exporting all grids in one file.

 

 

0
Petya
Telerik team
answered on 15 Dec 2015, 04:41 PM
Hi,

Right now we're not planning on exposing API targeted at exporting several RadGridView instances in a single sheet, but we'll definitely consider the scenario. I'll make sure to follow-up in this thread once the next release is officially out and the example I mentioned is available.

Regards,
Petya
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
0
Petya
Telerik team
answered on 20 Jan 2016, 04:01 PM
Hi,

As the Q1 2016 release went live last week, you can find the discussed demo in our SDK repository here. It shows how to export multiple RadGridView instances to a single XLSX file and to an existing on the file system XLSX document by utilizing our new export extensions and RadSpreadProcessing's CopyFrom() method for worksheets.

Regards,
Petya
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
Tags
GridView
Asked by
guobian
Top achievements
Rank 1
Answers by
Petya
Telerik team
guobian
Top achievements
Rank 1
Share this question
or