wb_add_style {openxlsx2}

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)

Arguments

wb

A workbook

style

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

style_name

style name used optional argument

Value

The wbWorkbook object, invisibly.

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)