How to open excel with a password?

[joanq]

Hi everyone!

Could you please help me with opening by Input an excel that has a password?

I would like to use workflow in Alteryx for a number of excels with password, so I prefer possibility to remove password/or possibility to read such file in Alteryx, rather than remove password in Excel every time I want to run workflow.

I know there are similar topics to this, but I don't know how to run macro in Alteryx.

Also, there is one advice to use Directory tool and then formula and R.

But I have no idea what to put in the formula tool to open excel.

I would be very grateful, I'm working on encrypted excels all the time.

[DeepikaSiriah30]

How did you install the package excel.link?

I tried the following code to install but I am still getting an error:

#repos <- c("http://cran.revolutionanalytics.com", "http://cran.rstudio.com")
#repo <- sample(repos,2)

install.packages(c("excel.link"), repos=repo, dependencies = TRUE)

[tomekgagola]

Would you have the same but with Python?

Also, any idea why the R scripts shows error as below?

Error: R (4): The R.exe exit code (3221225477) indicated an error.

[tomekgagola]

...

[sgaryali]

I tried using this but I am getting this type of error.

What can be the reason for this?

[sgaryali]

Hi

I used this but I am facing this error-

What can be done to resolve this?

[davidhe]

Hi @sgaryali were you ever able to find a solution? 

[pcatterson]

I think I have this working, but it just pulls the last sheet.  Is there a way to change the instructions to specify which sheet to bring into alteryx?

[mmmpnd]

Hi there ! I encountered this error and am not sure how to change the codes to get it working. 

Please help. Thanks.

 

[Tam]

@TylerNa contribution to this topic should be pinned.

[carl_cimino]

is there a way to do this with an Access Database?