This is a migrated thread and some comments may be shown as answers.

How to preserve details hidden elements when exporting to Excel

2 Answers 21 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
uvuvuv
Top achievements
Rank 1
uvuvuv asked on 10 Feb 2020, 06:02 PM

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

2 Answers, 1 is accepted

Sort by
0
Accepted
Martin Ivanov
Telerik team
answered on 13 Feb 2020, 09:35 AM

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

Get quickly onboarded and successful with your Telerik and/or Kendo UI products with the Virtual Classroom free technical training, available to all active customers. Learn More.
0
uvuvuv
Top achievements
Rank 1
answered on 13 Feb 2020, 09:44 AM

Thank you very much! This might work.

Tags
General Discussions
Asked by
uvuvuv
Top achievements
Rank 1
Answers by
Martin Ivanov
Telerik team
uvuvuv
Top achievements
Rank 1
Share this question
or