[Advanced Excel] Setting the Date format in outputted excel

Forge Component
(45)
Published on 11 Jun (5 days ago) by Hanno
45 votes
Published on 11 Jun (5 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.