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, 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.
Current stable version is available on CRAN via
install.packages("openxlsx", dependencies=TRUE)
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")
Thanks, here.
Here.
A list is automagically maintained here.