This R package simplifies the creation of .xlsx files by providing a high level interface to writing, styling and editing worksheets. Through the use of Rcpp, read/write times are comparable to the xlsx and XLConnect packages with the added benefit of removing the dependency on Java.


The openxlsx package requires a zip application to be available to R.

For Linux and MacOS this should be available by default.

For Windows, zip can be installed by installing Rtools

If the command R shell("zip") returns R 'zip' is not recognized as an internal or external command, operable program or batch file.

or similar. Then;

Stable version

Current stable version is available on CRAN via

install.packages("openxlsx", dependencies=TRUE)

Development version

Development version can be installed via GitHub once Rtools (Windows only) has been setup with:

install.packages(c("Rcpp", "devtools"), dependencies=TRUE)

Bug/feature request

Please let me know which version of openxlsx you are using when posting bug reports.


Thanks, here.



Authors and Contributors

A list is automagically maintained here.