Export to excel with additional coloumns and data that are not shown in the grid

2 posts, 0 answers
  1. Jena
    Jena avatar
    1 posts
    Member since:
    Sep 2017

    Posted 19 Oct 2017 Link to this post

    We are using telerik filter enabled radgrid that has 8 (say) columns and we have to export the filtered records  to excel when required and the excel report should have additional columns 25(say) with relevant data. Is there a possibility to achieve this? The frequency of exporting to excel is comparatively very low and hence loading all 25 rows and making the columns invisible will have considerable performance hit. 
  2. Eyup
    Admin
    Eyup avatar
    3824 posts

    Posted 24 Oct 2017 Link to this post

    Hi Jena,

    You can set the Visible property of the columns to True just before exporting them. Similar to the implementation demonstrated in the attached web site sample.

    I hope this will prove helpful.

    Regards,
    Eyup
    Progress Telerik
    Try our brand new, jQuery-free Angular components built from ground-up which deliver the business app essential building blocks - a grid component, data visualization (charts) and form elements.
Back to Top