[Solved] Export to Excel number format

[Gerwin]

I have the following problem.

When a number in the grid is formatted in the format used in France (10 123 in stead of 10.123) and when i export to excel, excel does not see this as a number, because of the space.

Is there a way that it will always be exported as 10123, so without any formatting?

[Kostadin]

Hello Gerwin,

I am not sure which Excel format you are using. If you are using Html-Based format you could remove the DataFormatString in code behind when export is fired. Note that if IgnorePaging property is set to false you have to call Rebind() method. Check out the following code snippet.

protected void Button1_Click(object sender, EventArgs e)
{
    GridBoundColumn col = RadGrid1.MasterTableView.GetColumn("Column1") as GridBoundColumn;
    col.DataFormatString = null;
    RadGrid1.MasterTableView.ExportToExcel();
}

All the best,
Kostadin
the Telerik team

[Gerwin]

Hi Kostadin.
Thank you for you're reaction.
This solution is working, but is it also possible to do this for all the columns at once?

[Shinu]

Hi,

Try the following code to loop through columns.
C#:

protected void Button1_Click(object sender, EventArgs e)
{
        foreach (GridBoundColumn col in RadGrid1.Columns)
        {
            col.DataFormatString = null;
        }
        RadGrid1.MasterTableView.ExportToExcel();
}

Thanks,
Shinu

[Gerwin]

Is it also possible to have formatting on a GridTemplateColumn?

[Shinu]

Hi,

You can format the columns as shown below.
C#:

protected void RadGrid1_ExportCellFormatting(object sender, ExportCellFormattingEventArgs e)
{
    if ((e.FormattedColumn.UniqueName) == "Uniquename")
    {
        e.Cell.Style["mso-number-format"] = @"$";

    }
}

Thanks,
Shinu