Dear Community,
May i know if there is any solution that we can use to read the excel protected file using alteryx?
I saw online that some of articles suggesting using the R-Code and would like to know if there is other method to do it?
Thank you.
Hey @SH_94,
Yeah you can import password protected files using the python tool (I've attached an example workflow). You will most definitely have to run the workflow in admin mode. Ping if you have any questions.
Put your directory in the first section (make sure to leave the r at the begining) and the password in the second
Example Workflow:
Give a green tick if it works
What happens if you set the Kernel to jupytertool_venu or continue without, can you still run the code? The Kernel is the program which runs the python code. By default my kernel is designerbasedtools. The reason may be that you haven't installed the admin version of Alteryx or the R based tools but I'm not sure just yet.
Hi @IraWatt ,
I have set it to jupytertool and it show the result as below:
May i know how can i fix the error for this part?
Many thanks again.
