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.
4 Answers, 1 is accepted
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.
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.
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.
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.