header row formatting does not work in export to excel

[Abhinandan Bansal]

I am adding columns in grid dynamically. The header row formatting does not comes in export to excel. i set the back color and fore color of header in the header style section of grid but nothing comes up in excel file.


Thanks,
Abhinandan Bansal

[Pavlina]

Hi Abhinandan,

Please review the followinh help topic for more information of RadGrid export styling.

Regards,
Pavlina
the Telerik team

[Abhinandan Bansal]

I tried with all the events mentioned in this topic  but it still did not work. My header text of column is like Email<br/>Sent and then i set the HtmlEncode to false to render it. I also set the background color of column header but it did not come in excel during export. Code of my grid is:
  <telerik:RadGrid runat="server" ID="grdLMA" EnableEmbeddedSkins="false" AutoGenerateColumns="false"
                                            CellPadding="4" ForeColor="#333333" GridLines="None" Width="90%">
                                            <MasterTableView AllowSorting="false" AllowPaging="false" Width="100%" >

                                            </MasterTableView>
                                            <HeaderStyle Wrap="false" BackColor="#5D7B9D" ForeColor="White" Font-Bold="true"/>
                                            <ExportSettings ExportOnlyData="true" FileName="Roll-up Live Report" Excel-FileExtension="xls" Excel-Format="ExcelML"
                                            OpenInNewWindow="true"></ExportSettings>
                                            <ItemStyle BackColor="#F7F6F3" ForeColor="#333333" />
                                            <AlternatingItemStyle BackColor="White" ForeColor="#284775" />
                                            <ClientSettings>
                                                <Scrolling UseStaticHeaders="true" AllowScroll="true" SaveScrollPosition="true"/>
                                                <Resizing AllowColumnResize="true" AllowRowResize="true" ClipCellContentOnResize="false" ResizeGridOnColumnResize="true" />
                                            </ClientSettings>
                                            <FooterStyle BackColor="#5D7B9D" ForeColor="White" Font-Bold="true"/>
                                            </telerik:RadGrid>

Please advice me on this.

Thanks,
Abhinandan Bansal

[Pavlina]

Hello Abhinandan,

I tried to replicate the described issue but to no avail. Attached to this message is a sample project for you to test locally. Please, try to replicate the problem that you encounter in it and let me know  what steps to follow, so that we can test it too.

Best wishes,
Pavlina
the Telerik team