ColorScaleRule

Source code

Description

Backwards compatibility

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

Usage

ColorScaleRule(
  start_type = NULL,
  start_value = NULL,
  start_color = NULL,
  mid_type = NULL,
  mid_value = NULL,
  mid_color = NULL,
  end_type = NULL,
  end_value = NULL,
  end_color = NULL,
  ...
)

Arguments

start_type	start_type
start_value	start_value
start_color	start_color
mid_type	mid_type
mid_value	mid_value
mid_color	mid_color
end_type	end_type
end_value	end_value
end_color	end_color
…	Additional arguments, i.e. kwargs.

Value

An openpyxl Python object.

Examples

library("xlcharts")

ColorScaleRule(
start_type='percentile', start_value=10, start_color='FFAA0000',
mid_type='percentile', mid_value=50, mid_color='FF0000AA',
end_type='percentile', end_value=90, end_color='FF00AA00')