Excel Export for Hierarchial data in the RadGridView

6 posts, 0 answers
  1. Raja
    Raja avatar
    15 posts
    Member since:
    Jun 2008

    Posted 07 Aug 2008 Link to this post

    Hi,

              Is there a method or a work around to Export the heirarchial RadGridView data to Excel?

    I tried the following methods:
    1. Using Telerik.Data.RadGridViewExcelExporter 
    2. Using RadGridReportingLite. sample code using RadLite.

                (RadGridReport rep = new RadGridReport(strFileName);

                rep.ReportFormShow(

    this, this.radGridView1);

    both of them are exporting only MasterTable Data. child Table data is not exported.

    Please suggest any solution.

    Thank you,
    Raja.

  2. Martin Vasilev
    Admin
    Martin Vasilev avatar
    1061 posts

    Posted 08 Aug 2008 Link to this post

    Hi Raja,

    Thank you for writing.

    Currently, RadControls suite does not include support of exporting child views of RadGridView to Excel. The main reason is because Excel has not build-in support for hierarchical data. Nevertheless, I will highly appreciate if you share with me how do you want to present hierarchy RadGridView in Excel spreadsheet. We always take into consideration on any good customer's idea and we could implement it in the feature versions.

    I am looking forward to your reply.

    Best wishes,
    Martin Vasilev
    the Telerik team

    Check out Telerik Trainer, the state of the art learning tool for Telerik products.
  3. UI for WinForms is Visual Studio 2017 Ready
  4. Daniel
    Daniel avatar
    1 posts
    Member since:
    Jul 2008

    Posted 08 Apr 2009 Link to this post

    I have the same need to export hierarchical data from a RadGridView to Excel.  It would be perfectly acceptable if the "child" rows where just indented one column so you could easily tell where in the heirarchy the rows are.  An example is below.

    Thanks,
    - Daniel

    master column, column, column, column, column, column
    master column, column, column, column, column, column
    master column, column, column, column, column, column
                    child column, column, column, column, column, column
                    child column, column, column, column, column, column
                    child column, column, column, column, column, column
    master column, column, column, column, column, column
    master column, column, column, column, column, column
    master column, column, column, column, column, column
                    child column, column, column, column, column, column
                    child column, column, column, column, column, column
                            child column, column, column, column, column, column
                            child column, column, column, column, column, column
    master column, column, column, column, column, column


  5. Martin Vasilev
    Admin
    Martin Vasilev avatar
    1061 posts

    Posted 10 Apr 2009 Link to this post

    Hello Daniel,

    Thank you very much for sharing your opinion with us.

    We did not implement such an exporting format because this will not be a real hierarchical data. With the suggested format you cannot make any excel data formatting operation such as sorting, filtering, column editing etc. Nevertheless we will consider this as a possible option that we could include in the future versions and especially if we receive more demand for the same format.

    I have updated your Telerik points for the suggestion. Do not hesitate to contact me again if you have other questions.  

    All the best,
    Martin Vasilev
    the Telerik team

    Check out Telerik Trainer , the state of the art learning tool for Telerik products.
  6. Jason
    Jason avatar
    9 posts
    Member since:
    Nov 2008

    Posted 14 Apr 2011 Link to this post

    Guys,

    I rad with interest the thread on hierarchical data from RadGridView to Excel and wondered if any of this functionality had thus far been implemented in the latest WinForm tools?  I tried attach a couple of excel sheets that show a couple of way I would like to see the data exported but the format is not permitted; is there a way to get .xls files to you?  I also attach a screen grab of the app so you can visualise how the data is being used.

    Thanks,

    Jason.
  7. Martin Vasilev
    Admin
    Martin Vasilev avatar
    1061 posts

    Posted 19 Apr 2011 Link to this post

    Hi Jason,

    Thank you for writing.

    Actually, I have some good news here. We have implemented exporting hierarchical data in our latest release Q1 2011 (2011.1.11.315). You just have to set the ExportHierarchy property to true:
    ExportToExcelML excelExporter = new ExportToExcelML(radGridView);
    excelExporter.ExportHierarchy = true;
    excelExporter.ExportVisualSettings = true;
    excelExporter.RunExport(filePath);

    Let me know if you have any additional questions.

    All the best,
    Martin Vasilev
    the Telerik team
    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 Public Issue Tracking system and vote to affect the priority of the items
Back to Top
UI for WinForms is Visual Studio 2017 Ready