Password encrypted input file

Hi there!

I have a password encrypted Excel file that I would like to use as an input to my Alteryx workflow. Read that this can be done by using the R tool. However, I cannot seem to download the R tool.

Does anyone have any alternative solution or is able to direct me to the right place to download this?

Thank you!

Developer Tools

Accepted answers

vizAlter

Hi @xiaohui1 — R application comes with Alteryx at the time of installation when you have Alteryx Predictive Tools package. However, you may download it through Download and Use Predictive Tools and this webpage has a short tutorial as well.

Also, check this link: https://community.alteryx.com/t5/Alteryx-Designer-Discussions/how-to-install-R-tool/m-p/433783/highlight/true#M81530

Please mark this post "Solved" if answers your query.

seinchyiwoo

Hey Xiaohui,

There is macro created by Ben Moss from Information Lab that allows you to use a password protected Excel as input data.

You can download his macro here: https://gallery.alteryx.com/#!app/Input-Password-Protected-XLSX/5a9d23a7826fd31b1c2826ea

It's using windows command script instead of R.

More notes prior connecting can be found on the gallery page as well.

Hope this helps.

Best,

Seinchyi

All comments

vizAlter

Also, check this link: https://community.alteryx.com/t5/Alteryx-Designer-Discussions/how-to-install-R-tool/m-p/433783/highlight/true#M81530

Please mark this post "Solved" if answers your query.

seinchyiwoo

Hey Xiaohui,

There is macro created by Ben Moss from Information Lab that allows you to use a password protected Excel as input data.

You can download his macro here: https://gallery.alteryx.com/#!app/Input-Password-Protected-XLSX/5a9d23a7826fd31b1c2826ea

It's using windows command script instead of R.

More notes prior connecting can be found on the gallery page as well.

Hope this helps.

Best,

Seinchyi

vizAlter

@xiaohui1 — Thank you!

xiaohui1

Thank you for your help, really clarifies everything! 🙂

limonma

Hi Seinchyi,

Thanks for sharing this. This actually works for fixed file and sheet names. I'm not sure if I am missing something in the code, but will it be possible to access the password encrypted file with file name that is changing every month or by using wildcards?

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703