Export to Excel

[Carlos Amigo]

I'm exporting a radgrid to Excel successfully. This is my code

gvwMaterial.ExportSettings.ExportOnlyData = true;
gvwMaterial.ExportSettings.IgnorePaging = true;
gvwMaterial.ExportSettings.OpenInNewWindow = true;
gvwMaterial.ExportSettings.Excel.Format = GridExcelExportFormat.Html;
gvwMaterial.ExportSettings.FileName = String.Format("File_{0}_{1}_in_{2}.xls", aaa, bbb.ToString(), ccc.ToString());
gvwMaterial.MasterTableView.ExportToExcel();

When Excel is opened, numbers with decimals, (percents like 0.12), are rounded to 0 or 1
How I can to format this columns?

Thanks

Carlos 

[Daniel]

Hello Carlos,

You can set the desired number format using the mso-number-format attribute as explained in our documentation:
Word/Excel export (HTML-based)

Let me know if you need more information.

Kind regards,
Daniel
the Telerik team