Problem exporting EUR currency to excel

[Alex]

Hi! I am writing to you because I have a problem when I try to export a column with euro currency data to an Excel file. It seems to change the format when exporting so I can't see the data the same way as in the grid. I am attaching a .zip file that reproduces the error. Can you help me please? :-) Thanks in advance and have a nice day.

Attachment: currencyexport_f633e4b2.zip

[Praveenkumar Gajendiran]

Hi Alex,

Thanks for contacting Syncfusion support.

We checked your query and provided sample. Based on that we suggest you to use the “currencyCode” property of Grid to export “EUR” currency to excel. Please refer the below code example for more information.

Code Example: 

<template> 

  <div id="app"> 

    <ejs-grid ref="grid" :dataSource="data"  currencyCode="EUR" :allowExcelExport="true" :toolbar="['ExcelExport']"  :toolbarClick="toolbarClick"> 

        <e-columns> 

          <e-column field='OrderID' headerText='Order ID' textAlign='Right' width=90></e-column> 

          <e-column field='CustomerID' headerText='Customer ID' width=120></e-column> 

          <e-column field='Freight'  headerText='Freight' textAlign='Right' format='C2' width=90></e-column> 

        </e-columns> 

    </ejs-grid> 

  </div> 

</template> 

Screenshot: 

 

We have modified your provided sample based on this for your reference.

Sample: https://www.syncfusion.com/downloads/support/directtrac/159629/ze/currencyexport_f633e4b2-1038199266.zip 

Please get back to us if you need further assistance.

Regards,
Praveenkumar G 

[Alex]

Hi!

Thank you very much for responding so quickly. Now it works perfectly :-)

Have a nice day!

[Ajith Govarthan]

Hi Alex, 

 

Thanks for the update. 

 

We are happy to hear that your issue has been resolved. 

 

Please get back to us if you need further assistance. 

 

Regards, 

Ajith G.