Despite the fact that Excel is the most widespread application for data manipulation and (perhaps) analysis, R’s support for the xls and xlsx file formats has left a lot to be desired. Fortunately, the XLConnect package has been created to fill this void, and now JGR 1.7-8 includes integration with XLConnect package to load .xls and .xlsx documents into R.
Not fancy, but very useful.
2 replies on “Reading Excel data is easy with JGR and XLConnect”
Hi Ian,
it’s great to see an integration of XLConnect in JGR. Cool stuff – very useful!
Best regards,
Martin
Wish I found this package sooner
I had to read in multiple sheets from an .xls into [R].
Did it with a for loop and was painfully slow