Read Excel Sheet in R
There are several packages available for reading Excel xls/xlsx files:
- Function*odbcConnectExcel* in package RODBC
- Package xlsx
- Function read.xls in package gdata
On some other blog articles (here is one)
Install Package XLSX
Package homepage on CRAN: http://cran.r-project.org/web/packages/xlsx/index.html
Notice: you might need to install dependency package xlsxjars and rJava, and make sure you have link JDK to R correctly, otherwise, execute the following in terminal as root:
R CMD javareconf
to add Java support to R.
Import Data from Excel Sheet
Since the Excel spread sheet include some instruction information, I need to specify the columns and rows which stores the "real" data.