How to read a .xls file that is encrypted with R?

Question

I usually use a package readxl(which is good) to read excel files:

 read_excel(path = 'ihateexcel.xls', sheet = 1)

However, the session will freeze substantially if I try to read the encrypted .xls file. Obviously, I do not want to save the file as .csv, because I will lose encryption or should use different encryption. This function does not seem to be found in other packages xlsx.

How to read .xls file encrypted in excel?

Answer 1

excel.link can help you open password protected files.

You can pass your password in one of the arguments.

Using

xl.read.file(filename, ...... password = NULL)