0

I am trying to open the file in this link (or you can access the download from this page if you want to see what you are downloading) in R on a Mac and I am getting errors with every package I have tried (readxl, xlsx, r2excel, openxlsx). Here is one error:

java.lang.IllegalArgumentException: Your InputStream was neither an OLE2 stream, nor an OOXML stream.

The file is advertised as xls, but my guess it is is malformed XLM, so that is why it won't open. Actually, on my Mac I can't even open it in Numbers. I am sure people with Excel can open it no problem. Anyone have any suggestions on how to open in R? Thanks in advance.

Roger J Bos CFA
  • 474
  • 4
  • 16

0 Answers0