feature request: format_dateTimes arg to write_excel_csv

[t-kalinowski]

Excel fails to correctly parse POSIXct columns with the default write_excel_csv settings. Can write_excel_csv have an arg with a sensible default specifying how to format POSIXct columns so excel can properly recognize them?

something like this

write_excel_csv(..., format_POSIXct = '%Y/%m/%d %H:%M')

and it would do something like this:

df <- mutate_if(df, lubridate::is.POSIXct, funs(format.POSIXct(x, '%Y/%m/%d %H:%M')))

[lock]

This old issue has been automatically locked. If you believe you have found a related problem, please file a new issue (with reprex) and link to this issue. https://reprex.tidyverse.org/