Expand description
Conditional formatting builder and utilities.
Provides a high-level API for adding, querying, and removing conditional formatting rules on worksheet cells. Supports cell-is comparisons, formula-based rules, color scales, data bars, duplicate/unique values, top/bottom N, above/below average, and text-based rules.
Structs§
- Conditional
Format Rule - A single conditional formatting rule with its style.
- Conditional
Style - Style applied by a conditional formatting rule.
Enums§
- CfOperator
- Comparison operator for CellIs conditional formatting rules.
- CfValue
Type - Value type for color scale and data bar thresholds.
- Conditional
Format Type - The type of conditional formatting rule.
Functions§
- delete_
conditional_ format - Delete all conditional formatting rules for a specific cell range.
- get_
conditional_ formats - Get all conditional formatting rules from a worksheet.
- set_
conditional_ format - Set conditional formatting rules on a cell range. Each call adds a new
conditionalFormattingelement with one or morecfRulechildren.