create_cell_style {openxlsx2}

Helper to create a cell style

Description

Helper to create a cell style

Usage

create_cell_style(
  border_id = "",
  fill_id = "",
  font_id = "",
  num_fmt_id = "",
  pivot_button = "",
  quote_prefix = "",
  xf_id = "",
  horizontal = "",
  indent = "",
  justify_last_line = "",
  reading_order = "",
  relative_indent = "",
  shrink_to_fit = "",
  text_rotation = "",
  vertical = "",
  wrap_text = "",
  ext_lst = "",
  hidden = "",
  locked = "",
  ...
)

Arguments

border_id

dummy

fill_id

dummy

font_id

dummy

num_fmt_id

a numFmt ID for a builtin style

pivot_button

dummy

quote_prefix

dummy

xf_id

dummy

horizontal

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

indent

dummy

justify_last_line

dummy

reading_order

dummy

relative_indent

dummy

shrink_to_fit

dummy

text_rotation

dummy

vertical

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

wrap_text

dummy

ext_lst

dummy

hidden

dummy

locked

dummy

...

reserved for additional arguments

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"	"@"

See Also

wb_add_cell_style()

Other style creating functions: create_border(), create_colors_xml(), create_dxfs_style(), create_fill(), create_font(), create_numfmt(), create_tablestyle()