⚠️There's a newer version (0.6.5) of this package. Take me there.

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')

Issues/Mailing list

To report a bug, use the Issues page at [issues] [issues]: https://github.com/dragua/xlsx/issues

Questions should be asked on the dedicated mailing [list] [list]: http://groups.google.com/group/R-package-xlsx

Copy Link

Version

Down Chevron

Install

install.packages('xlsx')

Monthly Downloads

320,122

Version

0.6.1

License

GPL-3

Issues

Pull Requests

Stars

Forks

Last Published

June 11th, 2018

Functions in xlsx (0.6.1)