5 Answers, 1 is accepted
0
Hello Stargazer,
You have to set some export to excel specific properties in RadGridView columns. GridViewDataColumn has a properties such as ExcelExportType and ExcelExportFormatString. Using these properties you can specify the exported data type supported by Excel. ExcelExportFormatString specify the format string only when the excel export type is Custom.
I hope this helps.
Kind regards,
Boyko Markov
the Telerik team
Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.
You have to set some export to excel specific properties in RadGridView columns. GridViewDataColumn has a properties such as ExcelExportType and ExcelExportFormatString. Using these properties you can specify the exported data type supported by Excel. ExcelExportFormatString specify the format string only when the excel export type is Custom.
I hope this helps.
Kind regards,
Boyko Markov
the Telerik team
Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.
0

Stargazer
Top achievements
Rank 2
answered on 22 Apr 2009, 10:36 AM
I Boyko!
I think I might have explained myself poorly. I can export my grid with no problems and with all the data. What I'm not being able to do is to export the Column Groups, of my grid set up with ColumnGroupView.
Is this achievable with those properties you told me about?
Thanks!
I think I might have explained myself poorly. I can export my grid with no problems and with all the data. What I'm not being able to do is to export the Column Groups, of my grid set up with ColumnGroupView.
Is this achievable with those properties you told me about?
Thanks!
0
Hi Stargazer,
We do not support exporting of ColumnGroups to Excel in the current version of RadGridView. We will consider implementing this feature in the next major release of RadControls for Winforms. I am sorry for the inconvenience. Please do not hesitate to write us back if you have further questions.
Kind regards,
Boyko Markov
the Telerik team
Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.
We do not support exporting of ColumnGroups to Excel in the current version of RadGridView. We will consider implementing this feature in the next major release of RadControls for Winforms. I am sorry for the inconvenience. Please do not hesitate to write us back if you have further questions.
Kind regards,
Boyko Markov
the Telerik team
Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.
0

Stargazer
Top achievements
Rank 2
answered on 14 Jul 2009, 05:59 PM
Hello Boyko!
Any news about this one? Is now possible to do this in Q2 2009?
If not, can you guys provide me some pointer on how to do this as easily as possible?
Thank you!
Regards!
Any news about this one? Is now possible to do this in Q2 2009?
If not, can you guys provide me some pointer on how to do this as easily as possible?
Thank you!
Regards!
0
Hi Stargazer,
Thank you for the questions.
We did our homework on this feature, however it turned out that there is no easy way to export the groups, because MS Excel does not support the same type of groups as GridViews do. So, there is no satisfactory implementation of this feature. If you would like to try this yourself, feel free to review Excel's programming guides, as well data formats that are supported.
All the best,
Martin Vasilev
the Telerik team
Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.
Thank you for the questions.
We did our homework on this feature, however it turned out that there is no easy way to export the groups, because MS Excel does not support the same type of groups as GridViews do. So, there is no satisfactory implementation of this feature. If you would like to try this yourself, feel free to review Excel's programming guides, as well data formats that are supported.
All the best,
Martin Vasilev
the Telerik team
Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.