openxlsx: xlsx reading, writing and editing.
Description
openxlsx simplifies the the process of writing and styling Excel xlsx files from R
and removes the dependency on Java.
Details
The openxlsx package uses global options to simplfy formatting:
options("openxlsx.borderColour" = "black")
options("openxlsx.borderStyle" = "thin")
options("openxlsx.dateFormat" = "mm/dd/yyyy")
options("openxlsx.datetimeFormat" = "yyyy-mm-dd hh:mm:ss")
options("openxlsx.numFmt" = NULL)
options("openxlsx.paperSize" = 9) ## A4
options("openxlsx.orientation" = "portrait") ## page orientation
See the Formatting vignette for examples.