Reading protected excel file

[SH_94]

Dear community,

I would like to ask how can we read the protected excel file in alteryx?

I have tried to look for resource and they use R tools to to read the data. I keep having the error as below :

Hence, would like to ask if there is any other way to read the protected excel file? Or do anyone know how to fix the error above?

Thank you.

[binuacs]

@SH_94 This can be done using Python, I think @PhilipMannering can give you more information about how this can be done in Python.

[SH_94]

Hi @binuacs ,

How about in alteryx?

Thank you

[binuacs]

@SH_94 the below post might be helpfull

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/How-To-Read-Extract-password-protec...

[Kamran1991]

Hi @SH_94,

I am also looking for this solution.

[apathetichell]

Run Alteryx as Admin. It's telling you it can't write the required R package to the proper directory. I usually would get around this by using RTools as a package manager and installing to that location. Alteryx as Admin should work.