Skip to contents

Create basic Excel Styles and provides a way to modify them

Source: R/excel_styles.R
excel_styles.Rd

excel_styles creates a series of styles used across the package and provides a way to modify them to increase the performance of the styling functions.

Usage

excel_styles(
  billion = NULL,
  style_category = NULL,
  type_data = NULL,
  fontName = "Calibri",
  billion_fgFill = NULL,
  hide = FALSE,
  ...
)

Arguments

billion

Billion to be used for billion styling when relevant: either "hep", "hpop", "uhc", or NULL when no billion to be applied.

style_category

category of style to be used. Can be either:

  • "title"

  • "subtitle"

  • "datatable_header": for column headers of data tables

  • "sub_datatable_header": for sub-headers of data tables

  • "data" : for standard data points

  • "normal_text"

  • NULL when no category applies

type_data

type of data. Can be either "date", "numeric", or "integer".

fontName

character name with the name of the font to use.

billion_fgFill

character with the type of billion color to be used. Passed to openxlsx::createStyle() fgFill parameter.

hide

bolean. Set fontColor to white and hidden to TRUE in openxlsx::createStyle()

...

additional parameters to be passed to openxlsx::createStyle(). Overrides any of the parameter passed by previous parameters.

See also

createStyle