Export radgridview data to excel

2 posts, 0 answers
  1. sriparthu
    sriparthu avatar
    3 posts
    Member since:
    Jul 2011

    Posted 01 Feb 2016 Link to this post


    I am facing an issue when exporting radgridview data to an excel.
    For example, if I have 7 columns in the radgridview in which the last column is hidden and
    I try to export the rad grid data to excel.
    I see only 6 columns i.e. the columns only which are visible in radgridview but
    I want to export all the columns to the excel irrespective of their visibility in the grid.

    Please let me know if there are any options to set to make the hidden columns visible
    in export or is there any other approach?

    Thanks in Advance
  2. Stefan Nenchev
    Stefan Nenchev avatar
    538 posts

    Posted 02 Feb 2016 Link to this post

    Hello Spirarthu,

    Indeed, by design if any of RadGridView`s columns is hidden it will not be exported. I suggest you making the specific columns visible before exporting the grid and eventually hiding them again right after the operation. I have prepared a sample project for your reference. Please review it and update me if there are any issues.

    Stefan Nenchev
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
Back to Top