How to preserve details hidden elements when exporting to Excel

[uvuvuv]

Dear Developers,

 

Thank you very much for this library.

Although, could anyone tell if it is possible to preserve row details when exporting and having a button to toggle their visibility like it looks inside RadGridView?

Preview: https://i.imgur.com/xjXpTgL.png

 

For example, there is an option to add details using HTML exporting and appending to string like here https://docs.telerik.com/devtools/silverlight/controls/radgridview/events/export-events#exporting is shown, but this will make these details visible by default.

Is it possible to hide them by default and have something like a checkbox or button to show/hide these details in exported for each row?

 

Best regards

[Martin Ivanov]

Hello,

This is not supported out of the box. However, you can achieve your requirement, by exporting RadGridView to a Workbook object (Excel document model), and then modify the Workbook as desired. There is no row-details-like feature in Excel, but you can insert new cell (or cells) in the Workbook and expand its column span in order to mimic row details. Then, you can use the grouping feature of RadSpreadProcessing (the Workbook's product) to enable expand/collapse in the produced document.

I hope this helps.

Regards,
Martin Ivanov
Progress Telerik

[uvuvuv]

Thank you very much! This might work.