The package is described by the author like this:
openxlsx: Read, Write and Edit XLSX Files
Simplifies the creation of Excel .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.
This can make a repetitive task where the deliverable is a multi-tabbed Excel workbook a scriptable task. I only used a small part of the package’s capabilities and found the tools easy to use. The basic gist in the way I used the packages was to:
- Create a workbook object in R
- Add data sets to it (each data set is a tab)
- Write it out to a file
There is also tooling to do all sorts of styling and other ways to impress your boss.
## Load dependencies if (!require('openxlsx')) install.packages('openxlsx') library('openxlsx') ## Split data apart by a grouping variable; ## makes a named list of tables dat
To leave a comment for the author, please follow the link and comment on their blog: R – TRinker's R Blog.
R-bloggers.com offers daily e-mail updates about R news and tutorials on topics such as: Data science, Big Data, R jobs, visualization (ggplot2, Boxplots, maps, animation), programming (RStudio, Sweave, LaTeX, SQL, Eclipse, git, hadoop, Web Scraping) statistics (regression, PCA, time series, trading) and more...
Source:: R News