FormulaRule: FormulaRule

In xlcharts: Create Native 'Excel' Charts and Work with Microsoft 'Excel' Files

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)

xlcharts documentation built on May 29, 2024, 7:58 a.m.