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,
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(); });
thank you for the solution. That is exactly what I need for the solution.
Hello Jens,
I am glad that you find Martin`s suggestion helpful.
Thank you for using Infragistics components.