I am presenting data in a grid, either as a date, time or date/time. When we export to Excel, it is defaulting all to the same date format. I would like to override the format for the times when exporting. I have dug through the code and found that if I add a format: "h:mm" to the data object in the ExcelExportEvent.workbook.sheets.rows.cells it does work as I want.
The issue is that the ExcelExportEvent columns definition does not include the data needed to go back and look at my original data to look up the right format. I need the field name so i can look up the format to apply, and then line up the column indices, etc.
For example, in this image you see the columns only contain width and autoWidth. Of course some columns may be hidden, so I cannot use the indices directly.
I am hoping perhaps there is a way I can add properties to the Grid Column which are picked up by the Excel export.
Thank you for your time!