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
dummy
- quote_prefix
dummy
- xf_id
dummy
- horizontal
alignment can be ”, 'general', 'left', 'center', 'right', 'fill', 'justify', 'centerContinuous', 'distributed'
- indent
dummy
- justify_last_line
dummy
- reading_order
dummy
- relative_indent
dummy
- shrink_to_fit
dummy
- text_rotation
dummy
- vertical
alignment can be ”, 'top', 'center', 'bottom', 'justify', 'distributed'
- wrap_text
dummy
- ext_lst
dummy
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
Other style creating functions:
create_border(),
create_colors_xml(),
create_dxfs_style(),
create_fill(),
create_font(),
create_numfmt(),
create_tablestyle()