How do you read a password protected excel file into r?

Question

How do you read a password protected excel file into r?

I have tried excel.link but its not available for R version 3.2.3 (My version)

I also tried RDCOMClient but it is also not available for R version 3.2.3

Answer 1

I just used xl.read.file from the excel.link package.

https://rdrr.io/cran/excel.link/man/xl.read.file.html

It was very straightforward.

Using the same test file from the previous answer (https://github.com/miraisolutions/xlconnect/files/794219/TestWorkbook.xlsx).

install.packages("excel.link")  library("excel.link")  dat <- xl.read.file("TestWorkbook.xlsx", password = "pass", write.res.password="pass")  dat 

(The file I needed only had one password, unlike the test file, so I didn't need the last argument for my use.)