OneDrive Output Preserve Formatting Ability

[heathersolis]

Hello,

I am using the OneDrive Output tool to export a .xlsx file. I was able to export the file to my desired OneDrive location; however, the date years are exported incorrectly (2093 instead of 2023) in all of my date columns. My results show the correct date, so I'm unsure why it changes.

Additionally, I'd like to append to the same file but preserve the formatting to show the full column widths and hide a column for future monthly runs. When I run using the Append option, the previously saved formatting goes away, some of the columns are excluded, and the date columns change to a datetime format (with the incorrect years as mentioned above). 

Is there a way to preserve the Excel file formatting using the OneDrive Output tool?

[ArnaldoSandoval]

Hi @heathersolis 

It could be a encoding issue, have you try a different code page, like UTF-8 or UTF-32 if you get the same result (2093) I will check the date field, trying to format it as text in Alteryx,

hth

Arnaldo