RadGrid Export Excel "HeaderText" field as Column Name

[nagendra]

Hi All,

I have radgrid. I have some columns which have HeaderText is different from that of DataFeild column. When i do ExporttoExcel i need to export the HeaderText Column name as First row in the column.

<telerik:GridTemplateColumn DataField="ErrorText" HeaderButtonType="TextButton" HeaderText="Poster Response"
                                               UniqueName="ErrorText" Visible="true"  SortExpression="ErrorText">
                                               <HeaderStyle HorizontalAlign="left" Width="135px" />
                                               <ItemStyle HorizontalAlign="left" />
                                               <ItemTemplate>
                                                   <asp:Label ID="lblErrorText" runat="server" Text='<%# DataBinder.Eval(Container.DataItem, "ErrorText")%>'>
                                                   </asp:Label>
                                               </ItemTemplate>
                                           </telerik:GridTemplateColumn>

Even i want to export only Visible Columns. For Example in this column i have ErrorText as DataField , Poster Response as HeaderText when i export to excel i want the Poster Response as Column name in Excel instead of ErrorText. Please let me know the solution.

[Jayesh Goyani]

Hello,

<telerik:RadGrid ID="RadGrid2" runat="server" AutoGenerateColumns="false" OnNeedDataSource="RadGrid2_NeedDataSource">
            <ExportSettings ExportOnlyData="true"></ExportSettings>
            <MasterTableView DataKeyNames="ID" CommandItemDisplay="Top">
                <CommandItemSettings  ShowExportToExcelButton="true" />
                <Columns>
                    <telerik:GridBoundColumn DataField="ID" HeaderText="ID" UniqueName="ID">
                    </telerik:GridBoundColumn>
                    <telerik:GridBoundColumn DataField="Name" HeaderText="Name" UniqueName="Name">
                    </telerik:GridBoundColumn>
                    <telerik:GridTemplateColumn DataField="Name" HeaderButtonType="TextButton" HeaderText="Poster Response"
                        UniqueName="ErrorText" Visible="true" SortExpression="ErrorText">
                        <HeaderStyle HorizontalAlign="left" Width="135px" />
                        <ItemStyle HorizontalAlign="left" />
                        <ItemTemplate>
                            <asp:Label ID="lblErrorText" runat="server" Text='<%# DataBinder.Eval(Container.DataItem, "Name")%>'>
                            </asp:Label>
                        </ItemTemplate>
                    </telerik:GridTemplateColumn>
                </Columns>
            </MasterTableView>
        </telerik:RadGrid>

protected void RadGrid2_NeedDataSource(object sender, Telerik.Web.UI.GridNeedDataSourceEventArgs e)
       {


           dynamic data = new[] {
               new { ID = 1, Name ="name1"},
               new { ID = 2, Name = "Name2"},
               new { ID = 3, Name = "name3"},
               new { ID = 4, Name = "Name4"},
                new { ID = 1, Name ="name1"},
               new { ID = 2, Name = "Name2"},
               new { ID = 3, Name = "name3"},
               new { ID = 4, Name = "Name4"},
                new { ID = 1, Name ="name1"},
               new { ID = 2, Name = "Name2"},
               new { ID = 3, Name = "name3"},
                new { ID = 1, Name ="name1"},
               new { ID = 2, Name = "Name2"},
               new { ID = 3, Name = "name3"},
                new { ID = 1, Name ="name1"},
               new { ID = 2, Name = "Name2"},
               new { ID = 3, Name = "name3"},
                new { ID = 1, Name ="name1"},
               new { ID = 2, Name = "Name2"},
               new { ID = 3, Name = "name3"},
                new { ID = 1, Name ="name1"},
               new { ID = 2, Name = "Name2"},
               new { ID = 3, Name = "name3"},
                new { ID = 1, Name ="name1"},
               new { ID = 2, Name = "Name2"},
               new { ID = 3, Name = "name3"},
                new { ID = 1, Name ="name1"},
               new { ID = 2, Name = "Name2"},
               new { ID = 3, Name = "name3"},
               new { ID = 4, Name = "Name4"},
                new { ID = 1, Name ="name1"},
               new { ID = 2, Name = "Name2"},
               new { ID = 3, Name = "name3"},
               new { ID = 4, Name = "Name4"},
                new { ID = 1, Name ="name1"},
               new { ID = 2, Name = "Name2"},
               new { ID = 3, Name = "name3"},
                new { ID = 1, Name ="name1"},
               new { ID = 2, Name = "Name2"},
               new { ID = 3, Name = "name3"},
                new { ID = 1, Name ="name1"},
               new { ID = 2, Name = "Name2"},
               new { ID = 3, Name = "name3"},
               new { ID = 4, Name = "Name4"},
                new { ID = 1, Name ="name1"},
               new { ID = 2, Name = "Name2"},
               new { ID = 3, Name = "name3"},
               new { ID = 4, Name = "Name4"},
                new { ID = 1, Name ="name1"},
               new { ID = 2, Name = "Name2"},
               new { ID = 3, Name = "name3"},
               new { ID = 4, Name = "Name4"},
                new { ID = 1, Name ="name1"},
               new { ID = 2, Name = "Name2"},
               new { ID = 3, Name = "name3"},
               new { ID = 4, Name = "Name4"},
                new { ID = 1, Name ="name1"},
               new { ID = 2, Name = "Name2"},
               new { ID = 3, Name = "name3"},
               new { ID = 4, Name = "Name4"},
                new { ID = 1, Name ="name1"},
               new { ID = 2, Name = "Name2"},
               new { ID = 3, Name = "name3"},
               new { ID = 4, Name = "Name4"},
                new { ID = 1, Name ="name1"},
               new { ID = 2, Name = "Name2"},
               new { ID = 3, Name = "name3"},
               new { ID = 4, Name = "Name4"},
               new { ID = 4, Name = "Name4"},
               new { ID = 4, Name = "Name4"},
               new { ID = 4, Name = "Name4"},
               new { ID = 4, Name = "Name4"},
               new { ID = 4, Name = "Name4"},
               new { ID = 4, Name = "Name4"},
               new { ID = 4, Name = "Name4"},
               new { ID = 4, Name = "Name4"},
               new { ID = 5, Name = "name5"}
           };
           RadGrid2.DataSource = data;

       }

I am not able to reproduce the issue.
Please check above code snippet and i also attached file.

Thanks,
Jayesh Goyani

[Spiros]

Hi Jayesh .
How I can export the  RadGrid1.MasterTableView.Caption = "&&&&&"
in Master Detail Grid .
Thanks

[Kostadin]

Hi Spiros,

I answered your question in the following forum thread, so if you have more questions I would recommend you to continue there and close this one.

Regards,
Kostadin
Telerik