31Oct/11Off
Reading Excel data is easy with JGR and XLConnect
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.
October 31st, 2011 - 17:45
Hi Ian,
it’s great to see an integration of XLConnect in JGR. Cool stuff – very useful!
Best regards,
Martin
October 31st, 2011 - 18:19
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