Export to excel ... preserve format

[Rajz]

Hello,

While exporting grid data, the data dispalyed in grid such as $8,000.00 is exported as just 8000 instead of $8,000.

Is there a way to preserve the format while exporting to excel?

Thank you

Regards
Raj

[Daniel]

Hello Raj,

I suggest that you examine the Number formats / Formulas section in the following topic:
Word/Excel export (HTML-based)

Let me know if you need more information.

Regards,
Daniel
the Telerik team

[Rajz]

That was good!

But my footer text is not formatted, How do I apply the format to footer too?

Thank you

Regards
Raj

[Daniel]

Hello Raj,

You could use the same approach in order to apply custom styles/number format to the footer row/cells.

Sample code:

protected void RadGrid1_ItemCreated(object sender, GridItemEventArgs e)
{
    if (e.Item is GridFooterItem && isExport)
    {
        GridFooterItem item = e.Item as GridFooterItem;
        item["myColumnName"].Style.Add("mso-number-format", ...);
    }
}

I hope this helps

Best regards,
Daniel
the Telerik team