This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
This tool allows you to pass a password and file location of a password protected excel file and input its data into Alteryx.
Once installed it will appear in the In/Out tool group.
Please comment for any improvements.
Just right click then insert the macro into your workflow, then pass over the password and file location.
Dear @IraWatt .
Could you please advise on the following queries?
1. Does it need to use the input the text tool?
2. Could you share with me the complete worklfow including the input text tool so that i can replicate what you have done as i not sure how to run it despite i know i have to insert the macro?
I have different view as compared to you as per screenshot below:
Many thanks and hope to hear from you soon.
After some investigation I found this: Error: Failed to find virtual env named: "designer... - Alteryx Community you will need to upgrade designer to update your python environment.
Hi @IraWatt ,
Thanks a lot for the prompt response. May i know if there is any version that work well for 2020 version?
Thanks for your sharing with the Password Protected Excel Input Tool, I tried to use it but encountering some error messages as indicated below.
May I seek for further advice on the issue?
Grateful if you could provide advice on it.
Is there a link to output excel password protect macro?
thanks for this amazing tool
but header shown as a column and new header appears
also how i can select specific tab sheet if i have more than tab sheet
Awesome! Thanks - Is there a tool for outputting to password protected excel file.
I have the same problem as @Ryan_Li
Please can you explain me, what is wrong.. There is a solution ?
thank you !