Generate a style with variable color or bolding

add_style_wrapper() adds a style for use within timeseries_style(), where the font color and decoration needs to vary based on data type. Wraps around openxlsx::addStyle() and openxlsx::createStyle().

Usage

add_style_wrapper(wb, sheet_name, rows, cols, fontColour, textDecoration)

Arguments

wb

a openxlsx workbook to be edited.

sheet_name

character name of the sheet to update

rows

Rows to apply style to, passed to openxlsx::add_style().

cols

Columns to apply style to, passed to openxlsx::add_style().

fontColour

Font colour, passed to openxlsx::createStyle().

textDecoration

Font decoration, passed to openxlsx::createStyle().