Learn R Programming

openxlsx2 (version 1.7)

create_cell_style: 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()