R: FormulaRule

FormulaRule {xlcharts}

R Documentation

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,
  ...
)

Arguments

`formula`	formula
`stopIfTrue`	stopIfTrue
`font`	font
`border`	border
`fill`	fill
`...`	Additional arguments, i.e. kwargs.

Value

An openpyxl Python object.

Examples

## Not run: 
wb <- Workbook()
ws <- wb$active
ws$conditional_formatting$add('E1:E10',
  FormulaRule(
    formula = list('ISBLANK(A1)'),
    stopIfTrue=TRUE
  )
)

## End(Not run)

[Package xlcharts version 0.0.2 Index]