Import excel files into R. Supports '.xls' via the embedded 'libxls' C library < https://sourceforge.net/projects/libxls/> and '.xlsx' via the embedded 'RapidXML' C++ library < https://rapidxml.sourceforge.net>. Works on Windows, Mac and Linux without external dependencies.
The readxl package makes it easy to get data out of Excel and into R. Compared to many of the existing packages (e.g. gdata, xlsx, xlsReadWrite) readxl has no external dependencies so it's easy to install and use on all operating systems. It is designed to work with tabular data stored in a single sheet.
Readxl supports both the legacy
.xls format and the modern xml-based
.xls support is made possible the with libxls C library, which abstracts away many of the complexities of the underlying binary format. To parse
.xlsx, we use the RapidXML C++ library.
You can install:
library(readxl)# read_excel reads both xls and xlsx filesread_excel("my-old-spreadsheet.xls")read_excel("my-new-spreadsheet.xlsx")# Specify sheet with a number or nameread_excel("my-spreadsheet.xls", sheet = "data")read_excel("my-spreadsheet.xls", sheet = 2)# If NAs are represented by something other than blank cells,# set the na argumentread_excel("my-spreadsheet.xls", na = "NA")
Re-encodes non-ASCII characters to UTF-8.
Loads datetimes into POSIXct columns. Both Windows (1900) and Mac (1904) date specifications are processed correctly.
Blank columns and rows are automatically dropped.
It returns data frames with additional
tbl_df class, so if you have
dplyr loaded, you get nicer printing.
The package includes an example file created with openxlsx:
l <- list("iris" = iris, "mtcars" = mtcars, chickwts = chickwts, quakes = quakes)openxlsx::write.xlsx(l, file = "inst/extdata/datasets.xlsx")
_x005F_) (#51, thanks to @jmarshallnz).