Export to Excel with wrapping headers.

[John]

Hi!

I have a Gridview, containing loads of columns. Some of the column headers are a bit wide, so therefore we use a Textblock in the header to wrap it and make it look a bit better.
Now I'm trying to export the data I have in the grid to Excel and it works great, until I look at the headers using the textblock where its instead of the actual header saying "System.Windows.Controls.TextBlock" now.

<telerik:RadGridView.Columns>
                <telerik:GridViewDataColumn UniqueName="ProductCode" Width="150" DataMemberBinding="{Binding Task.ProductCode}" IsGroupable="False">
                    <telerik:GridViewDataColumn.Header>
                            <TextBlock Text="Delivery Item (Task Product-doc nr)"
                                       TextWrapping="Wrap"/>
                    </telerik:GridViewDataColumn.Header>

                </telerik:GridViewDataColumn>

Is there any way to do and export of the actual header instead? :)

[Ivan Ivanov]

Hello John,

I have prepared an example project for your case. Please, refer to it and inform us if this approach meets your requirements.

Greetings,
Ivan Ivanov
the Telerik team

[John]

Great sample, and works perfectly! Thanks for all the help!