Radgrid Export to Excel Column width

[Eric]

Hi,

We need to set the column width in export to excel file. Currently, its fit the width by using its Header Text. We need to customize it like in grid we have 50px column width but when we export to excel we want to set 20px. How can we achieve the goal? Any sample application would be appreciated.

[Eyup]

Hello Eric,

Supposing that you are using the following Excel export format:

<ExportSettings>
    <Excel Format="Xlsx" />
</ExportSettings>

You can use the following approach to achieve this requirement:

protected void RadGrid1_PreRender(object sender, EventArgs e)
{
    if (RadGrid1.IsExporting)
    {
        foreach (GridColumn col in RadGrid1.MasterTableView.RenderColumns)
        {
            if (col.UniqueName == "ShipCountry")
            {
                col.HeaderStyle.Width = 500;
                break;
            }
        }
    }
}

I hope this will prove helpful.

Regards,
Eyup
Progress Telerik