Excel file reading

[Ajith1]

Hi All,

I'm newly added Alteryx please guide to me below requirement 

I need a read password protected xlsx. an input file in alteryx Could you please suggest to me.

[RishiK]

@Ajith1 have a look at this previous article:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/How-to-open-excel-with-a-password/td-p...

I had posted a sample workflow there which will help you also

[Ajith1]

Thank you for the quick response.

I'm tried as per your link but it will be shown an error in R language

is it possible to solve the without R??

[RishiK]

@Ajith1what error are you getting?

I am tagging in @PeterA here who wrote about the R solution some time back 

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/A-quick-tip-for-reading-in-password-pr...

to see if he can help with the error you are receiving?

I know this has been raised as an Idea:

https://community.alteryx.com/t5/Alteryx-Designer-Ideas/Data-Input-Output-Password-Protected-Files-E...

[Ajith1]

@RishiK 
I don't have knowledge on R.

Could you please suest to me is it possible? we can achieve without R

<Configuration>
<RScript><![CDATA[# install.packages(c("excel.link"),repos='https://cran.revolutionanalytics.com/',dependencies = TRUE)
library("excel.link")

df <- read.Alteryx("#1", mode="data.frame")
filename <- as.character(df[1,"FullPath"])
excel_pwd <- as.character(df[1,"excel_password"])

excel_data <- xl.read.file(filename, password = excel_pwd, write.res.password=excel_pwd)

write.Alteryx(excel_data, 1)
]]></RScript>
<UseFullUpdate value="True" />
</Configuration>

[Ajith1]

@RishiK

 Could you please help me Below error in the R

R (9) Error in library(xlsx) : there is no package called 'xlsx'

[pedrodrfaria]

Hi @Ajith1 

It means that you have not installed the R Package that is required. Please use this to be able to install it.

Run it as an Analytic App and inset in the first text box the name of the package, this case would be XLSX.

If you ever encounter another error similar to this, is simply because the R Package was not installed. For example if you want to read pdfs you will need to install the pdftools R package.

Please let us know if you need any additional help.

Pedro.