Hello,
I have a number column for which I use ng-template with CurrencyPipe to display multiple currencies. Is there a method by which when I export to excel to export also the currencies?
Thanks,
Anca
Hello Anca,
Thank you for posting to Infragistics Community!
I have been looking into your question and an approach I could suggest, in order to achieve your requirement, is to subscribe to the rowExporting event of the excelExporter service and format the number column like the following:
this.excelExportService.rowExporting.subscribe( (args: IRowExportingEventArgs) => { args.rowData.Rate = this.currencyPipe.transform( args.rowData.Rate, this.getCurrency(args.rowData), 'code' ); } );
I have prepared a small sample where I am formatting the data of the “Rate” column using CurrencyPipe’s transform method.
Here could be found my sample for your reference. Please test it on your side and let me know if you need any further information regarding this matter.
Looking forward to hearing from you.
Sincerely, Riva Ivanova Entry Level Software Developer
Thank you for your quick answer. I test your solution and it work!
Thank you
Sincerely,
Anca Theodora
I am glad that you find my suggestion helpful.Thank you for using Infragistics components.
Regards,Riva IvanovaEntry Level Software Developer