openxlsx

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.

Installation

The openxlsx package requires a zip application to be available to R, such as the one that comes with Rtools, available here. (Windows only)

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;

• Install Rtools from: https://CRAN.R-project.org/bin/windows/Rtools/ and modify the system PATH during installation.

• If Rtools is installed, add the Rtools bin directory paths (default installation paths are c:and c:-4.6.3) to the system PATH variable.

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)
require(devtools)
install_github("awalker89/openxlsx")

Bug/feature request

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

packageVersion("openxlsx")

Thanks, here.

News

Here.

Authors and Contributors

A list is automagically maintained here.