RadGridView ExportToXlsx

[Kristaps]

Hi, 

I have problem of setting specific format for exporting data to excel. 

I wanted to use culture.NumberFormat.NumberGroupSeparator to set up no seperator and export it to excel.

But when setting modified culture to ExportToXlsx as a parameter, it doesnt affect anything.

I am doing something wrong?

[Dilyan Traykov]

Hello Kristaps,

Could you please specify whether you've defined a DataFormatString for the column as this way the cell value will be exported in the same format as the value in the GridViewCell?

In such a scenario, you can handle the ElementExportingToDocument event and parse the exported value as per your requirements. Here's an example:

this.radGridView.ElementExportingToDocument += (s, e) =>
{
    if (e.Element == ExportElement.Cell)
    {
        var cellExportingArgs = e as GridViewCellExportingEventArgs;
        if ((cellExportingArgs.Column as GridViewDataColumn).DataType == typeof(int))
        {
            e.Value = int.Parse(e.Value.ToString().Replace(",", ""));
        }
    }
};

Please let me know if you find this applicable.

Regards,
Dilyan Traykov
Progress Telerik