openxlsx2 (version 1.4)

wb_add_style: Set the default style in a workbook

Description

wb wrapper to add style to workbook

Usage

wb_add_style(wb, style = NULL, style_name = NULL)

Value

The wbWorkbook object, invisibly.

Arguments

wb

A workbook

style

style xml character, created by a create_*() function.

style_name

style name used optional argument

See Also

• create_border()

• create_cell_style()

• create_dxfs_style()

• create_fill()

• create_font()

• create_numfmt()

Other workbook styling functions: base_font-wb, wb_add_dxfs_style(), wb_base_colors

Examples

yellow_f <- wb_color(hex = "FF9C6500")
yellow_b <- wb_color(hex = "FFFFEB9C")

yellow <- create_dxfs_style(font_color = yellow_f, bg_fill = yellow_b)
wb <- wb_workbook() %>% wb_add_style(yellow)