R - Excel (xlsx )

> Procedural Languages > R

1 - About

xlsx read, write, format Excel 2007 (xlsx) files

3 - Management

3.1 - Installation

install.packages("xlsx")
package ‘rJava’ successfully unpacked and MD5 sums checked
package ‘xlsxjars’ successfully unpacked and MD5 sums checked
package ‘xlsx’ successfully unpacked and MD5 sums checked
Advertising

3.2 - Read

read.xlsx or read.xlsxx

  • The read.xlsx function provides the conveniency of read.table by borrowing from its signature.
  • The read.xlsx2 function does more work in Java so it achieves better performance (an order of magnitude faster on sheets with 100,000 cells or more).

Return data type: A data.frame or a list, depending on the as.data.frame argument.

require(xlsx)
setwd("path/To/XlsxFile") # Set the working directory
res <- read.xlsx2("data.xlsx", sheetIndex=1, as.data.frame=TRUE, header=TRUE)  # read first sheet
head(res)

where:

  • colClasses: a character vector that represents the class of each column. Only numeric, character, Date, POSIXct, column types are accepted