Hi,
we need to export datetime values to excel. The datetime value in the dataobject is ISO 8601 (for example 2020-06-01...) It is possible to render the value in the cell before export? Is there a callback for rendering? I only found the onColumnExport hook. But this is not for rendering the content.
Thanks.
Hello Jens,
I am glad that you find Martin`s suggestion helpful.
Thank you for using Infragistics components.
Hello,
thank you for the solution. That is exactly what I need for the solution.
Thank you for posting in our community.
By subscribing to the onRowExport event of IgxExcelExporterService, the date value can be modified before exporting:
this.excelExportService.onRowExport.subscribe((args: IRowExportingEventArgs) => { args.rowData.HireDate = args.rowData.HireDate.toISOString(); });