Skip to main content

CellValueConditionalFormat

Import from @reductoai/xlsx/officejs.

CellValueConditionalFormat properties

CellValueConditionalFormat.set()

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

CfStore

The rules of one worksheet, each with a handle token that lives as long as the rule. Not exported by name. You get it from the API.

CfStore properties

CfStore.read()

CfStore.rule()

CfStore.update()

CfStore.write()

ColorScaleConditionalFormat

Import from @reductoai/xlsx/officejs.

ColorScaleConditionalFormat properties

ColorScaleConditionalFormat.set()

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

ConditionalDataBarNegativeFormat

Import from @reductoai/xlsx/officejs.

ConditionalDataBarNegativeFormat properties

ConditionalDataBarNegativeFormat.set()

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

ConditionalDataBarPositiveFormat

Import from @reductoai/xlsx/officejs.

ConditionalDataBarPositiveFormat properties

ConditionalDataBarPositiveFormat.set()

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

ConditionalFormatRule

Excel.ConditionalFormatRule: a custom format’s formula. Import from @reductoai/xlsx/officejs.

ConditionalFormatRule properties

ConditionalFormatRule.set()

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

ConditionalRangeBorder

Import from @reductoai/xlsx/officejs.

ConditionalRangeBorder properties

ConditionalRangeBorder.set()

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

ConditionalRangeBorderCollection

Import from @reductoai/xlsx/officejs.

ConditionalRangeBorderCollection properties

ConditionalRangeBorderCollection.getItem()

ConditionalRangeBorderCollection.getItemAt()

ConditionalRangeFill

Import from @reductoai/xlsx/officejs.

ConditionalRangeFill properties

ConditionalRangeFill.clear()

ConditionalRangeFill.set()

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

ConditionalRangeFont

Import from @reductoai/xlsx/officejs.

ConditionalRangeFont properties

ConditionalRangeFont.clear()

ConditionalRangeFont.set()

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

ConditionalRangeFormat

Excel.ConditionalRangeFormat: what a rule lays over the cells it matches. Import from @reductoai/xlsx/officejs.

ConditionalRangeFormat properties

ConditionalRangeFormat.clearFormat()

ConditionalRangeFormat.set()

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

CustomConditionalFormat

Import from @reductoai/xlsx/officejs.

CustomConditionalFormat properties

CustomConditionalFormat.set()

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

DataBarConditionalFormat

Excel.DataBarConditionalFormat. Import from @reductoai/xlsx/officejs.

DataBarConditionalFormat properties

DataBarConditionalFormat.set()

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

IconSetConditionalFormat

Excel.IconSetConditionalFormat. Import from @reductoai/xlsx/officejs.

IconSetConditionalFormat properties

IconSetConditionalFormat.set()

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

PresetCriteriaConditionalFormat

Import from @reductoai/xlsx/officejs.

PresetCriteriaConditionalFormat properties

PresetCriteriaConditionalFormat.set()

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

TextConditionalFormat

Import from @reductoai/xlsx/officejs.

TextConditionalFormat properties

TextConditionalFormat.set()

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

TopBottomConditionalFormat

Import from @reductoai/xlsx/officejs.

TopBottomConditionalFormat properties

TopBottomConditionalFormat.set()

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