Excel file reading

Question

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.

pedrodrfaria · Answer

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.

Install R Packages.yxwz

Ajith1 · Answer

RishiK

Could you please help me Below error in the R

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

21.PNG

Ajith1 · Answer

RishiK I don't have knowledge on R. Could you please suest to me is it possible? we can achieve without R