Error Reading XLS files into R - cannot parse file

Question

I tried installing java and using the XLConnect package mmethods (both of them) but I get an error that looks like this:

Error: IOException (Java): Your InputStream was neither an OLE2 stream, nor an OOXML stream

I am definitely not trying to load an empty file, and I definitely do have access to/permission to read from the file location. What might I be doing wrong?

I tried installing java and using the XLConnect package mmethods (both of them) but I get an error that looks like this:

Error: IOException (Java): Your InputStream was neither an OLE2 stream, nor an OOXML stream

I am definitely not trying to load an empty file, and I definitely do have access to/permission to read from the file location. What might I be doing wrong?

I've investigated these related questions without success.

Importing Excel files into R, xlsx or xls

R read_excel: libxls error: Unable to parse file

Answer 1

Check the below code, it works with library(readxl)

xls and xslx both work