Export all rows to excel in RadTreeListView

[rahul]

I am exporting the data in RadTreeListView using Export function, it exports only the rows expanded by user manullay but I want to export all the rows irrespective users have expanded it or not. I have 10000 rows in a tree and users have to drill down manually all the rows one by one in a tree to export all the rows.
How can I export all the rows in RadTreeListView without expandign it? 

[Vlad]

Hello,

 You can call ExpandAllHierarchyItems() before exporting. 

All the best,
Vlad
the Telerik team

[rahul]

Hi Vlad,
Thanks for your prompt reply, but that will forcefully change the users's view as it will expand all the nodes,which I do not want.
 
How if I can have the one more grid as replica and set the visible property to it's false and can use that grid for export purpose, but can we have better approach as I have 10000 records in a grid and I don't want to load it twice?

[Marik]

Did you found a better solution (than call ExpandAllHierarchyItems())?

[Du]

You can use function ExpandAllItems(), Example: RadTreeList1.ExpandAllItems()

[Prithvi]

Hi, 

I have a radtreelistview. I want to do export excel, but not all elements, only elements which are visible to the user(some are collapased and some are expanded), only those which are visible should be exported.

Pls Help.

[Maya]

Hello,

You can handle ElementExporting event and cancel it for the rows/ items that you do not want to be exported.

Regards,
Maya
Telerik