xlcharts (version 0.0.1)

FormulaRule: FormulaRule

Description

Conditional formatting with custom differential style

https://openpyxl.readthedocs.io/en/stable/api/openpyxl.formatting.rule.html

Usage

FormulaRule(
  formula = NULL,
  stopIfTrue = NULL,
  font = NULL,
  border = NULL,
  fill = NULL,
  ...
)

Value

An openpyxl Python object.

Arguments

formula

formula

stopIfTrue

stopIfTrue

font

font

border

border

fill

fill

...

Additional arguments, i.e. kwargs.

Examples

if (FALSE) {
wb <- Workbook()
ws <- wb$active
ws$conditional_formatting$add('E1:E10',
  FormulaRule(
    formula = list('ISBLANK(A1)'),
    stopIfTrue=TRUE
  )
)
}