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

shell("zip")

returns

'zip' is not recognized as an internal or external command, operable program or
batch file.

or similar. Then;

• Install Rtools from: http://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:\Rtools\bin and c:\Rtools\gcc-4.6.3\bin) 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")

On some Unix platforms, install_github has been reported not to work as expected. The current workaround is as follows; simple bash script (eg named r_install_github):

#!/bin/bash
# usage (eg):
#    r_install_github devtools hadley

cd /tmp && \
rm -rf R_install_github && \
mkdir R_install_github  && \
cd R_install_github && \
wget https://github.com/$2/$1/archive/master.zip && \
unzip master.zip
R CMD build $1-master && \
R CMD INSTALL $1*.tar.gz && \
cd /tmp && \
rm -rf R_install_github

and to install openxlsx (after giving execution permissions and putting it in a PATH directory):

r_install_github openxlsx awalker89

Bug/feature request

Thanks, here.

News

Here.

Authors and Contributors

A list is automagically maintained here.