How to read data from Excel into R: http://www.dummies.com/how-to/content/how-to-read-data-from-excel-into-r.html
- Make sure ‘Java Development Kit’ is installed on the computer
- To add Java support to R run this command as root:
#!/bin/bash R CMD javareconf
- Install and load the package in R
- Read Excel file
“OldExcelFormatException (Java): The supplied spreadsheet seems to be Excel 5.0/7.0 (BIFF5) format. POI only supports BIFF8 format (from Excel versions 97/2000/XP/2003)”
!! Only supports format from Excel versions 97/2000/XP/2003 !!
See gdata for newer Excel files!