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 🙂
Can you say more about what kind of trouble you're having? Is there an error message?
Two thoughts:
Thanks for the reply @Luke_C ,
I'm not sure where to find the "Preserve Formatting on Overwrite"?
The configuration of your output tool should look something like this. What version of Alteryx are you using?
This are the options available for me in output configuration
I'm using alteryx version 2019.3 x64
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
Will try updating and see if it works.
Thanks again!