Export to Excel and ColumnGroupView

6 posts, 0 answers
  1. Stargazer
    Stargazer avatar
    73 posts
    Member since:
    Jan 2007

    Posted 21 Apr 2009 Link to this post

    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!
  2. Boyko Markov
    Admin
    Boyko Markov avatar
    610 posts

    Posted 22 Apr 2009 Link to this post

    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.
  3. UI for WinForms is Visual Studio 2017 Ready
  4. Stargazer
    Stargazer avatar
    73 posts
    Member since:
    Jan 2007

    Posted 22 Apr 2009 Link to this post

    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!
  5. Boyko Markov
    Admin
    Boyko Markov avatar
    610 posts

    Posted 22 Apr 2009 Link to this post

    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.
  6. Stargazer
    Stargazer avatar
    73 posts
    Member since:
    Jan 2007

    Posted 14 Jul 2009 Link to this post

    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!
  7. Martin Vasilev
    Admin
    Martin Vasilev avatar
    1061 posts

    Posted 17 Jul 2009 Link to this post

    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.
Back to Top
UI for WinForms is Visual Studio 2017 Ready