| openxlsx {openxlsx} | R Documentation |
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, most to simplify formatting. These
are stored in the op.openxlsx object.
- openxlsx.bandedCols
FALSE
- openxlsx.bandedRows
TRUE
- openxlsx.borderColour
"black"
- openxlsx.borders
"none"
- openxlsx.borderStyle
"thin"
- openxlsx.compressionLevel
"9"
- openxlsx.creator
""
- openxlsx.dateFormat
"mm/dd/yyyy"
- openxlsx.datetimeFormat
"yyyy-mm-dd hh:mm:ss"
- openxlsx.headerStyle
NULL
- openxlsx.keepNA
FALSE
- openxlsx.na.string
NULL
- openxlsx.numFmt
NULL
- openxlsx.orientation
"portrait"
- openxlsx.paperSize
9
- openxlsx.tabColour
"TableStyleLight9"
- openxlsx.tableStyle
"TableStyleLight9"
- openxlsx.withFilter
NA Whether to write data with or without a filter. If NA will make filters with
writeDataTableand will not forwriteData
See the Formatting vignette for examples.
Additional options
Author(s)
Maintainer: Jan Marvin Garbuszus jan.garbuszus@ruhr-uni-bochum.de [contributor]
Authors:
Philipp Schauberger philipp@schauberger.co.at
Alexander Walker Alexander.Walker1989@gmail.com
Other contributors:
Luca Braglia [contributor]
Joshua Sturm [contributor]
Jordan Mark Barbone jmbarbone@gmail.com (ORCID) [contributor]
David Zimmermann david_j_zimmermann@hotmail.com [contributor]
See Also
vignette("Introduction", package = "openxlsx")vignette("formatting", package = "openxlsx")
for examples