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

Export to Excel, Grid Visible Set False

3 Answers 22 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Jeff Reinhardt
Top achievements
Rank 1
Jeff Reinhardt asked on 19 Mar 2010, 04:12 PM
Hello, I have a situation where I need to export a lot of data, however, I need to show only a few columns in the grid.  I tried adding all of the fields to the grid but have them invisible, however they do not then export.  Not thinking it would work I created a second grid and set it to visible false and of course I was right it did not work, I tried putting the grid in a table cell with a height of 0px but it expands for the grid anyway.

Basically, I need to export around 40+ fields to excel but I want to only show 5 in the grid on the page.

Is this possible or is there a workaround?

Jeff

3 Answers, 1 is accepted

Sort by
0
Daniel
Telerik team
answered on 24 Mar 2010, 08:59 PM
Hello Jeff,

For your convenience I created a runnable demo that shows how to hide the unwanted columns when exporting to Excel. Please test it on your end and let me know whether it behaves as expected.

Regards,
Daniel
the Telerik team

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 Public Issue Tracking system and vote to affect the priority of the items.
0
Jeff Reinhardt
Top achievements
Rank 1
answered on 25 Mar 2010, 10:23 PM
Ok,  maybe I was not clear, I want to hide them from the grid that shows on the page but I want them to be exported.

I have like 30 columns of data, but I only want 5 to show in the grid.  I want them all to be exported.
0
Daniel
Telerik team
answered on 30 Mar 2010, 05:23 PM
Hello Jeff,

I'm sorry for the misunderstanding. I created yet another demo for you - it is attached to this post.

Regards,
Daniel
the Telerik team

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 Public Issue Tracking system and vote to affect the priority of the items.
Tags
Grid
Asked by
Jeff Reinhardt
Top achievements
Rank 1
Answers by
Daniel
Telerik team
Jeff Reinhardt
Top achievements
Rank 1
Share this question
or