Fells Stats Know Your Data

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.

Comments (2) Trackbacks (0)
  1. Hi Ian,
    it’s great to see an integration of XLConnect in JGR. Cool stuff – very useful!
    Best regards,
    Martin

  2. 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


Trackbacks are disabled.