wb_add_style: Set the default style in a workbook

In openxlsx2: Read, Write and Edit 'xlsx' Files

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)

openxlsx2 documentation built on Oct. 18, 2024, 1:07 a.m.