Skip to main content

ConditionalFormatCollection

Excel.ConditionalFormatCollection: the rules that touch a range, in priority order. Import from @reductoai/xlsx/officejs.

ConditionalFormatCollection properties

ConditionalFormatCollection.add()

Adds a rule on the range at the top priority.

ConditionalFormatCollection.clearAll()

Removes every rule from the range’s cells; rules that also cover other cells keep those.

ConditionalFormatCollection.getCount()

ConditionalFormatCollection.getItem()

ConditionalFormatCollection.getItemAt()

ConditionalFormatCollection.getItemOrNullObject()

ConditionalFormat

Excel.ConditionalFormat: one rule; a handle stays valid until the rule is deleted. Import from @reductoai/xlsx/officejs.

ConditionalFormat properties

ConditionalFormat.changeRuleToCellValue()

ConditionalFormat.changeRuleToColorScale()

ConditionalFormat.changeRuleToContainsText()

ConditionalFormat.changeRuleToCustom()

ConditionalFormat.changeRuleToDataBar()

ConditionalFormat.changeRuleToIconSet()

ConditionalFormat.changeRuleToPresetCriteria()

ConditionalFormat.changeRuleToTopBottom()

ConditionalFormat.delete()

ConditionalFormat.duplicate()

Extension: a copy of the rule right after it, as Manage Rules’ Duplicate Rule makes.

ConditionalFormat.getRange()

The cells the rule covers; throws when they are not one rectangle.

ConditionalFormat.getRangeAddresses()

Extension: the addresses of every area the rule covers.

ConditionalFormat.getRangeOrNullObject()

ConditionalFormat.getRanges()

ConditionalFormat.set()

Sets several properties at once; a navigation member takes a nested batch.

ConditionalFormat.setRanges()

Moves the rule to other cells; formulas Excel writes for a typed rule follow the new top-left cell.

DataValidation

Excel.DataValidation: the rules on the cells of a range or of several areas. Import from @reductoai/xlsx/officejs.

DataValidation properties

DataValidation.clear()

DataValidation.getInvalidCells()

The cells whose values fail their rule; throws when every cell passes.

DataValidation.getInvalidCellsOrNullObject()

DataValidation.set()

Sets several properties at once; a navigation member takes a nested batch.