A quick introduction to the excellent R package openxlsx was presented at the April 11, 2016 Lansing Area R User Group meeting. This introduction includes examples demonstrating:
- Exporting a data.frame
- Including a stock image
- Including a ggplot2 image
- Including a formula
- Conditional formatting
- Numerical formatting
R code with the resulting xlsx file and slides are provided.
The current and stable version of openxlsx is available on CRAN and is installed using the command:
install.packages("openxlsx", dependencies=TRUE)The development version of openxlsx is available on GitHub and is installed using the command:
install.packages(c("Rcpp", "devtools"), dependencies=TRUE)
require(devtools)
install_github("awalker89/openxlsx")