Multiple GridView export to single file (pdf/xlsx)

5 posts, 0 answers
  1. guobian
    guobian avatar
    5 posts
    Member since:
    Aug 2011

    Posted 08 Dec 2015 Link to this post

    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, 

     

     

  2. Petya
    Admin
    Petya avatar
    975 posts

    Posted 11 Dec 2015 Link to this post

    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
  3. UI for WPF is Visual Studio 2017 Ready
  4. guobian
    guobian avatar
    5 posts
    Member since:
    Aug 2011

    Posted 14 Dec 2015 in reply to Petya Link to this post

    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.

     

     

  5. Petya
    Admin
    Petya avatar
    975 posts

    Posted 15 Dec 2015 Link to this post

    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
  6. Petya
    Admin
    Petya avatar
    975 posts

    Posted 20 Jan Link to this post

    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
Back to Top
UI for WPF is Visual Studio 2017 Ready