Jeff Reinhardt
Top achievements
Rank 1
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
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
0
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.
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
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.
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
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.
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.