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

[Anwar]

Hi,

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

Regards

[Anwar]

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

I urgently need confirmation regarding this matter.

Thank you

[Ivan Petrov]

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.

Greetings,
Ivan Petrov
the Telerik team