[Advanced Excel] Setting the Date format in outputted excel

Forge Component
(51)
Published on 27 Aug by Hanno
51 votes
Published on 27 Aug by Hanno

Is there a way to use this component to force Excel to format a date column to a pattern of choice? EG the format of dates in the platform is dd-mm-yyyy but we would like resultant Excel column to be a date in the format dd/mm/yyyy 

You can convert the date to the format you want using the FormatDate built-in action.

Paul Davies wrote:

Is there a way to use this component to force Excel to format a date column to a pattern of choice? EG the format of dates in the platform is dd-mm-yyyy but we would like resultant Excel column to be a date in the format dd/mm/yyyy 

As João Melo mentioned, at the moment you need to format before writing to excel. An upcoming version will have the option to set the number format on a cell.


Paul Davies, have you been able to use the NumberFormat property when writing data to solve your issue?