Export to Excel - Hierarchy (Child) rows only excluding Parent rows

3 posts, 0 answers
  1. Anwar
    Anwar avatar
    4 posts
    Member since:
    Oct 2012

    Posted 08 Mar 2013 Link to this post


    I would like to now whether the grid view are able to export the child rows only excluding the parent rows?

    The reason is, for my task current parent rows are just there as a summary of the child rows in a hierarchical view. Therefore, it does have details that is useful for excel manipulations.

    I understand that current grid view can export the grid parent rows and its hierarchy, however the output of the export is not clean and immediately ready for excel data manipulations, as it have repeating child headers and the child is indented one column from the left as screenshot of the existinghierarchyexport.png

    So i would like to confirm whether it is possible to have it with the only expectedchildrowsonly.png


  2. Anwar
    Anwar avatar
    4 posts
    Member since:
    Oct 2012

    Posted 10 Mar 2013 Link to this post

    Could someone, provide some information or alternatives ... Please?

    I urgently need confirmation regarding this matter.

    Thank you
  3. Ivan Petrov
    Ivan Petrov avatar
    718 posts

    Posted 13 Mar 2013 Link to this post

    Hello Anwar,

    Thank you for writing.

    Currently, the export mechanism does not support exporting only child data rows. However you can create an in-memory grid which contains only child table data and export it. For this to work you have to set the grid's BindingContext property to a new instance of BindingContext. This is needed to be able to bind the grid to the data. The rest is exactly the same as if you export a grid in the normal case. If you have any difficulties implementing this do not hesitate to write back and please include the schema of your data and the type of hierarchy you use for your grid.

    I hope this will be useful. Feel free to write back with any further questions.

    Ivan Petrov
    the Telerik team
    WinForms Q1 2013 boasts PivotGrid, PDF Viewer, Chart enhancements and more. Check out all of the latest highlights.
Back to Top