Learn R Programming

openxlsx2 (version 0.5.1)

create_cell_style: create_cell_style

Description

create_cell_style

Usage

create_cell_style(
  borderId = "",
  fillId = "",
  fontId = "",
  numFmtId = "",
  pivotButton = "",
  quotePrefix = "",
  xfId = "",
  horizontal = "",
  indent = "",
  justifyLastLine = "",
  readingOrder = "",
  relativeIndent = "",
  shrinkToFit = "",
  textRotation = "",
  vertical = "",
  wrapText = "",
  extLst = "",
  hidden = "",
  locked = ""
)

Arguments

borderId

dummy

fillId

dummy

fontId

dummy

numFmtId

a numFmt ID for a builtin style

pivotButton

dummy

quotePrefix

dummy

xfId

dummy

horizontal

alignment can be "", "center", "right"

indent

dummy

justifyLastLine

dummy

readingOrder

dummy

relativeIndent

dummy

shrinkToFit

dummy

textRotation

dummy

vertical

alignment can be "", "center", "right"

wrapText

dummy

extLst

dummy

hidden

dummy

locked

dummy

Details

"ID""numFmt"
"0""General"
"1""0"
"2""0.00"
"3""#,##0"
"4""#,##0.00"
"9""0%"
"10""0.00%"
"11""0.00E+00"
"12""# ?/?"
"13""# ??/??"
"14""mm-dd-yy"
"15""d-mmm-yy"
"16""d-mmm"
"17""mmm-yy"
"18""h:mm AM/PM"
"19""h:mm:ss AM/PM"
"20""h:mm"
"21""h:mm:ss"
"22""m/d/yy h:mm"
"37""#,##0 ;(#,##0)"
"38""#,##0 ;[Red](#,##0)"
"39""#,##0.00;(#,##0.00)"
"40""#,##0.00;[Red](#,##0.00)"
"45""mm:ss"
"46""[h]:mm:ss"
"47""mmss.0"
"48""##0.0E+0"
"49""@"