wb_base_colors {openxlsx2} | R Documentation |
Set the default colors in a workbook
Description
Modify / get the default colors of the workbook.
Usage
wb_set_base_colors(wb, theme = "Office", ...)
wb_get_base_colors(wb, xml = FALSE, plot = TRUE)
Arguments
wb |
A workbook object |
theme |
a predefined color theme |
... |
optional parameters |
xml |
Logical if xml string should be returned |
plot |
Logical if a barplot of the colors should be returned |
Details
Theme must be any of the following: "Aspect", "Blue", "Blue II", "Blue Green", "Blue Warm", "Greyscale", "Green", "Green Yellow", "Marquee", "Median", "Office", "Office 2007 - 2010", "Office 2013 - 2022", "Orange", "Orange Red", "Paper", "Red", "Red Orange", "Red Violet", "Slipstream", "Violet", "Violet II", "Yellow", "Yellow Orange"
See Also
Other workbook styling functions:
base_font-wb
,
wb_add_dxfs_style()
,
wb_add_style()
Other workbook wrappers:
base_font-wb
,
col_widths-wb
,
creators-wb
,
grouping-wb
,
row_heights-wb
,
wb_add_chartsheet()
,
wb_add_data()
,
wb_add_data_table()
,
wb_add_formula()
,
wb_add_pivot_table()
,
wb_add_slicer()
,
wb_add_worksheet()
,
wb_clone_worksheet()
,
wb_copy_cells()
,
wb_freeze_pane()
,
wb_merge_cells()
,
wb_save()
,
wb_set_last_modified_by()
,
wb_workbook()
Examples
wb <- wb_workbook()
wb$get_base_colors()
wb$set_base_colors(theme = 3)
wb$set_base_colors(theme = "Violet II")
wb$get_base_colours()