A couple of months ago I wrote a short blog post about a new library I discovered: openxlsx. Here’s a very short blog post as a followup.
To read in Excel files in R using the openxlsx library, I use the following function:
read.xlsx('file.xlsx')However, one day, I ran into the following error.
Error in file(con, “r”) : invalid ‘description’ argument
I lost half an hour trying to solve this error, so I’m gonna save you the troubles: if you have the file opened in Microsoft Excel or a free alternative, just close it ;-).
Good luck!