Welcome to the Gallery. Please feel free to post and comment, and check out our FAQ!

Community Gallery

Post, download, and share all of your favorite tools and workflows — from Alteryx supported to user-built.
Comments
Shifty
12 - Quasar

Nice!

IraWatt
17 - Castor

Thankyou MR @Shifty 

jsilavong
7 - Meteor

Hi @IraWatt , 

 

How do I configure this tool?

 

jsilavong_0-1654098450444.png

 

IraWatt
17 - Castor

Hey @jsilavong,

Just right click then insert the macro into your workflow, then pass over the password and file location.

IraWatt_0-1654098528441.png

 

IraWatt
17 - Castor

Let me know if the tool works alright for you @jsilavong !

SH_94
11 - Bolide

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:

SH_94_0-1655694765940.png

 

Many thanks and hope to hear from you soon.

 

 

IraWatt
17 - Castor

Hey @SH_94 and @jsilavong I have updated the tool to make it easier to install.

SH_94
11 - Bolide

Dear @IraWatt ,

 

Thank you for the prompt response.

 

I have the error as below and may i know how we can solve it?

SH_94_0-1657099999124.png

 

Thank you and hope to hear from you soon

 

IraWatt
17 - Castor

Hey @SH_94,

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. 

SH_94
11 - Bolide

Hi @IraWatt ,

 

Thanks a lot for the prompt response. May i know if there is any version that work well for 2020 version?

 

Thank you.

IraWatt
17 - Castor

@SH_94 The python environment was updated with version 2021.1.4 release so 2020 is not covered. 

Ryan_Li
5 - Atom

Hi @IraWatt,

 

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?

  1. Is it essential to use this add-on tool with the minimum version 2022.1 of Alteryx Designer? My current version is 2021.4
    Ryan_Li_1-1662435901213.png

     

  2. Is the error message  about the python package? I am not quite understand how to follow up the error to resolve it.....

Ryan_Li_3-1662436016186.png

 

Grateful if you could provide advice on it.

 

Thanks.

 

 

 

Gforce
5 - Atom

HI
Is there a link to output excel password protect macro?
thanks

MohammedSanad
5 - Atom

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 

 

thank you 

jsilavong
7 - Meteor

Awesome! Thanks - Is there a tool for outputting to password protected excel file.