ExcelExport Exports Hidden Columns In Child Tables

3 posts, 0 answers
  1. Albert
    Albert avatar
    27 posts
    Member since:
    Sep 2012

    Posted 18 Oct 2014 Link to this post

    I am using Telerik Silverlight version 2013.1.422.

    I have RadGridView bound to a hierarchical dataset. Some of the columns in child tables have IsVisible set to false. When I export to Excel, the hidden columns are included, but I do not want them to be. How can I hide them or prevent  them from being exported?

    When I export a flat dataset (no child tables) where some columns are hidden in the RadGridView, the export to Excel DOES NOT export the hidden columns. This is the behaviour I want with hierarchical datasets too.

    I have been trying to use the ElementExporing event to cancel the export if the element has a column with IsVisible set to false, but it it not working. Please, give me some guidance.

    Kind Regards,
  2. Albert
    Albert avatar
    27 posts
    Member since:
    Sep 2012

    Posted 19 Oct 2014 in reply to Albert Link to this post

    Figured it out. The problem was in some custom code in the ElementExporting event handler.
  3. DevCraft R3 2016 release webinar banner
  4. Dimitrina
    Dimitrina avatar
    3769 posts

    Posted 20 Oct 2014 Link to this post

    Hi Albert,

    You can also check the Export FAQ article on more frequently asked questions.


    Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.

Back to Top