[Advanced Excel] Setting the Date format in outputted excel

Forge Component
(50)
Published on 13 Aug (8 days ago) by Hanno
50 votes
Published on 13 Aug (8 days 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.