Join the Alteryx Community’s Maveryx Summer Cup event! Compete, network with others, and earn your gold through a series of challenges from July 24th to August 11th. Learn more about the event here.
community Alteryx IO Alteryx.com
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

How to read in passworded excel files?

wonka1234
10 - Fireball
‎11-21-2022 11:48 AM

Hi,

 

I am trying to read in a directory of files. I believe they are not being read in because of the password on each file.

I am using the input data tool to read it. Ie \Alteryx\Community\*.xlsx

They all have the same password.

Is there a way to bypass this?

I am getting unable to open file to read error and assume it is because of the passwords.

Labels:
Reply
0 Likes
1 REPLY 1
DavidSkaife
13 - Pulsar
‎11-21-2022 12:44 PM

Hi @wonka1234 

 

There is a Custom Macro available on the Gallery that can help you with this - https://community.alteryx.com/t5/Community-Gallery/Password-Protected-Excel-Input-Tool/ta-p/937928

Reply
apply to be an alteryx mentor
Join the tampa, florida User Group
Labels