How to preserve details hidden elements when exporting to Excel

3 posts, 1 answers
  1. uvuvuv
    uvuvuv avatar
    3 posts
    Member since:
    Dec 2019

    Posted 10 Feb Link to this post

    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. Answer
    Martin Ivanov
    Admin
    Martin Ivanov avatar
    2444 posts

    Posted 13 Feb Link to this post

    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.
  3. uvuvuv
    uvuvuv avatar
    3 posts
    Member since:
    Dec 2019

    Posted 13 Feb in reply to Martin Ivanov Link to this post

    Thank you very much! This might work.

Back to Top