/xlsx

An R package to interact with Excel files using the Apache POI java library

Primary LanguageR

xlsx

An R package to read, write, format Excel 2007 and Excel 97/2000/XP/2003 files

The package provides R functions to read, write, and format Excel files. Depends on Java, but this makes it available on most OS'es.

Install

Stable version from CRAN

install.packages('xlsx')

Or development version from GitHub

devtools::install_github('dragua/xlsx')

Quick start

To read the first sheet from spreadsheet into a data.frame

read.xlsx2('C:/temp/file.xlsx', 1)

To write a data.frame to a spreadsheet

write.xlsx2(iris, file='C:/temp/iris.xlsx')