ConditionalFormatCollection
Excel.ConditionalFormatCollection: the rules that touch a range, in priority order.
Import from @reductoai/xlsx/officejs.
ConditionalFormatCollection properties
ConditionalFormatCollection.add()
ConditionalFormatCollection.clearAll()
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()
ConditionalFormat.getRange()
ConditionalFormat.getRangeAddresses()
ConditionalFormat.getRangeOrNullObject()
ConditionalFormat.getRanges()
ConditionalFormat.set()
ConditionalFormat.setRanges()
DataValidation
Excel.DataValidation: the rules on the cells of a range or of several areas.
Import from @reductoai/xlsx/officejs.