Formatting Excel Output files

Question

Hi, 
I have been trying to write to the existing Excel file in the specified range without changing the excel format .
I used the configuration:
1. Output options :Overwrite Sheet 
2.In the output path  I have specified sheet name : "Sheet1$A2:Z"
When I run the workflow i'm having troubles in writing the data.
I would highly appreciate if anyone can tell me where the problem is .
Thanks a lot in advance 🙂

QurrathAmeena · Answer

Will try updating and see if it works.
Thanks again!

Luke_C · Answer

hi @QurrathAmeena

I think you'll need to consider updating to at least 2020.1. Looking at the release notes, preserving formatting was a feature introduced then.

https://help.alteryx.com/release-notes/designer/designer-20201-release-notes

QurrathAmeena · Answer

This are the options available for me in output configuration

I'm using alteryx version 2019.3 x64