[Advanced Excel] Setting the Date format in outputted excel

Forge Component
(51)
Published on 27 Aug (3 weeks ago) by Hanno
51 votes
Published on 27 Aug (3 weeks ago) 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?