Rule

Source code

Description

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

Usage

Rule(
  type,
  dxfId = NULL,
  priority = 0L,
  stopIfTrue = NULL,
  aboveAverage = NULL,
  percent = NULL,
  bottom = NULL,
  operator = NULL,
  text = NULL,
  timePeriod = NULL,
  rank = NULL,
  stdDev = NULL,
  equalAverage = NULL,
  formula = list(),
  colorScale = NULL,
  dataBar = NULL,
  iconSet = NULL,
  extLst = NULL,
  dxf = NULL,
  ...
)

Arguments

type	type
dxfId	dxfId
priority	priority
stopIfTrue	stopIfTrue
aboveAverage	aboveAverage
percent	percent
bottom	bottom
operator	operator
text	text
timePeriod	timePeriod
rank	rank
stdDev	stdDev
equalAverage	equalAverage
formula	formula
colorScale	colorScale
dataBar	dataBar
iconSet	iconSet
extLst	extLst
dxf	dxf
…	Additional arguments, i.e. kwargs

Value

An openpyxl Python object.

Examples

library("xlcharts")

Rule(type = "colorScale")