Export to Excel Missing Column Header Names

[Logan Marshall]

When I do the export to excel function its missing header name (first row in excel).  I'm dynamically renaming these columns in the page load event.  Could that be why? 

[Eyup]

Hello Logan,

It is a possibility. I've created a sample RadTreeList web site to test the described behavior. Can you please run the attached application and instruct me the exact steps I need to follow in order to reproduce the issue?

Regards,
Eyup
Telerik

 

 

[Logan Marshall]

Hello, Thank you so much for the example.  Can you try to rename column names on Page_Load and see if the export to Excel works?
Thanks so much

[Konstantin Dikov]

Hello Logan,

I have tested the sample that Eyup have provided in his reply, where I am changing the column names in the Page_Load event handler, but with auto-generated column, this will not have any effect at all. With auto-generated column, the column name and the header text will be automatically generated, depending on the underlying data field and for changing the names, the server-side OnAutoGeneratedColumnCreated should be handled and the HeaderText property must be set and not the UniqueName property:

protected void RadTreeList1_AutoGeneratedColumnCreated(object sender, TreeListAutoGeneratedColumnCreatedEventArgs e)
{
    TreeListColumn column = e.Column;
    //column.UniqueName = "Test " + column.UniqueName;
    column.HeaderText = "Test " + (column as TreeListDataColumn).DataField;
}

In scenarios where the columns are defined in the markup, the Page's Load event could be used as shown below:

protected void Page_Load(object sender, EventArgs e)
{
    foreach (TreeListColumn column in RadTreeList1.RenderColumns)
    {
        column.HeaderText = "Test " + (column as TreeListDataColumn).DataField;
    }
}

Hope this helps.


Regards,
Konstantin Dikov
Telerik