Currency symbol in excel export

[Daniel]

I'm trying to export the content of a Grid to Excel. The format of my currency columns and aggregates is set to C2 (Format="C2"). In Excel the currency data always shows $ as currency symbol except in the aggregates where € is the currency sysmbol.

How can I get € as currency symbol in all currency columns?

[Renjith Singh Rajendran]

Hi Daniel, 

 

Greetings from Syncfusion support. 

 

We are currently checking this from our side. We will update you further details within two business days. 

 

Until then we appreciate your patience. 

 

Regards, 

Renjith R 

[Renjith Singh Rajendran]

Hi Daniel, 

 

Based on this scenario, we suggest you to customize the corresponding formatted value based on current culture and assign to args.Cell.Value inside ExcelQueryCellInfoEvent handler to achieve this requirement. We have also prepared a sample for your reference, please download and refer the sample from the link below, 

Sample : https://www.syncfusion.com/downloads/support/directtrac/general/ze/GridLocalization_Wasm530289749 

 

Please refer the codes below, 

 

 

    <GridEvents OnToolbarClick="ToolbarClickHandler" ExcelQueryCellInfoEvent="ExcelQueryCellInfoEvent" TValue="Order"></GridEvents> 

 

    public void ExcelQueryCellInfoEvent(ExcelQueryCellInfoEventArgs<Order> args) 

    { 

        CultureInfo currentCulture = new CultureInfo("fr-BE"); 

        if (args.Column.Field == "Freight") 

        { 

            args.Cell.Value = args.Data.Freight.ToString("C2", currentCulture); 

        } 

    } 

 

 

Please get back to us if you need further assistance. 

 

Regards, 

Renjith R