R (1) Error in library("excel.link") : there is no package called 'excel.link'
R (1) Execution halted
R (1) The R.exe exit code (1) indicated an error.
this above error keeps popping up while I run the code to open an excel file in alteryx.
I tried the analytical app method of installing excel.link package but that didn't work either
any help is appreciated with this.
Code:
# 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)
