There are several ways to import data into R.
The standard way, what it used to be, is from a text file using read.table() function.
For excel files, the most famous spreadsheet software on the world, several libraries can be used to import data from .xls file, for example
. In the past, the problem was with the xlsx file, which was not supported yet.
Recently, I discovered that
can be used to import xlsx file now. So, this bypass the step that I normally have to save the excel file to text file and do the regular file import.
library(gdata) data <- read.xls(xls="myData.xlsx",sheet=1,header=TRUE, as.is=TRUE)