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

Export to Excel and ColumnGroupView

5 Answers 79 Views
GridView
This is a migrated thread and some comments may be shown as answers.
Stargazer
Top achievements
Rank 2
Stargazer asked on 21 Apr 2009, 10:04 AM
Hello all!

Can anyone tell me if it is possible to do an export of a grid to Excel,maintaining all the formats, including the Column Groups?

Thanks!

5 Answers, 1 is accepted

Sort by
0
Boyko Markov
Telerik team
answered on 22 Apr 2009, 09:03 AM
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.
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!
0
Boyko Markov
Telerik team
answered on 22 Apr 2009, 11:24 AM
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.
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!
0
Martin Vasilev
Telerik team
answered on 17 Jul 2009, 11:22 AM
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.
Tags
GridView
Asked by
Stargazer
Top achievements
Rank 2
Answers by
Boyko Markov
Telerik team
Stargazer
Top achievements
Rank 2
Martin Vasilev
Telerik team
Share this question
or