Excel.Interfaces.ConditionalFormatCollectionLoadOptions interface

代表与区域重叠的所有条件格式的集合。Represents a collection of all the conditional formats that are overlap the range.

[API 集: ExcelApi 1.6][ API set: ExcelApi 1.6 ]

属性

$all
cellValue

对于集合中的每一项: 如果当前条件格式为 CellValue 类型, 则返回 cell 值条件格式属性。For EACH ITEM in the collection: Returns the cell value conditional format properties if the current conditional format is a CellValue type. 例如, 设置5到10之间的所有单元格的格式。For example to format all cells between 5 and 10.

[API 集: ExcelApi 1.6][ API set: ExcelApi 1.6 ]

cellValueOrNullObject

对于集合中的每一项: 如果当前条件格式为 CellValue 类型, 则返回 cell 值条件格式属性。For EACH ITEM in the collection: Returns the cell value conditional format properties if the current conditional format is a CellValue type. 例如, 设置5到10之间的所有单元格的格式。For example to format all cells between 5 and 10.

[API 集: ExcelApi 1.6][ API set: ExcelApi 1.6 ]

colorScale

对于集合中的每一项: 如果当前条件格式为色阶类型, 则返回色阶条件格式属性。For EACH ITEM in the collection: Returns the ColorScale conditional format properties if the current conditional format is an ColorScale type.

[API 集: ExcelApi 1.6][ API set: ExcelApi 1.6 ]

colorScaleOrNullObject

对于集合中的每一项: 如果当前条件格式为色阶类型, 则返回色阶条件格式属性。For EACH ITEM in the collection: Returns the ColorScale conditional format properties if the current conditional format is an ColorScale type.

[API 集: ExcelApi 1.6][ API set: ExcelApi 1.6 ]

custom

对于集合中的每一项: 如果当前条件格式为自定义类型, 则返回自定义条件格式属性。For EACH ITEM in the collection: Returns the custom conditional format properties if the current conditional format is a custom type.

[API 集: ExcelApi 1.6][ API set: ExcelApi 1.6 ]

customOrNullObject

对于集合中的每一项: 如果当前条件格式为自定义类型, 则返回自定义条件格式属性。For EACH ITEM in the collection: Returns the custom conditional format properties if the current conditional format is a custom type.

[API 集: ExcelApi 1.6][ API set: ExcelApi 1.6 ]

dataBar

对于集合中的每一项: 如果当前条件格式为数据栏, 则返回数据栏属性。For EACH ITEM in the collection: Returns the data bar properties if the current conditional format is a data bar.

[API 集: ExcelApi 1.6][ API set: ExcelApi 1.6 ]

dataBarOrNullObject

对于集合中的每一项: 如果当前条件格式为数据栏, 则返回数据栏属性。For EACH ITEM in the collection: Returns the data bar properties if the current conditional format is a data bar.

[API 集: ExcelApi 1.6][ API set: ExcelApi 1.6 ]

iconSet

对于集合中的每一项: 如果当前条件格式为 IconSet 类型, 则返回 IconSet 条件格式属性。For EACH ITEM in the collection: Returns the IconSet conditional format properties if the current conditional format is an IconSet type.

[API 集: ExcelApi 1.6][ API set: ExcelApi 1.6 ]

iconSetOrNullObject

对于集合中的每一项: 如果当前条件格式为 IconSet 类型, 则返回 IconSet 条件格式属性。For EACH ITEM in the collection: Returns the IconSet conditional format properties if the current conditional format is an IconSet type.

[API 集: ExcelApi 1.6][ API set: ExcelApi 1.6 ]

id

对于集合中的每个项目: 当前 ConditionalFormatCollection 中条件格式的优先级。For EACH ITEM in the collection: The Priority of the Conditional Format within the current ConditionalFormatCollection. 只读。Read-only.

[API 集: ExcelApi 1.6][ API set: ExcelApi 1.6 ]

preset

对于集合中的每一项: 返回预设条件条件格式。For EACH ITEM in the collection: Returns the preset criteria conditional format. 有关更多详细信息, 请参阅 PresetCriteriaConditionalFormat。See Excel.PresetCriteriaConditionalFormat for more details.

[API 集: ExcelApi 1.6][ API set: ExcelApi 1.6 ]

presetOrNullObject

对于集合中的每一项: 返回预设条件条件格式。For EACH ITEM in the collection: Returns the preset criteria conditional format. 有关更多详细信息, 请参阅 PresetCriteriaConditionalFormat。See Excel.PresetCriteriaConditionalFormat for more details.

[API 集: ExcelApi 1.6][ API set: ExcelApi 1.6 ]

priority

对于集合中的每一项: 条件格式集合中当前存在此条件格式的优先级 (或索引)。For EACH ITEM in the collection: The priority (or index) within the conditional format collection that this conditional format currently exists in. 更改此设置还会更改其他条件格式的优先级, 以允许进行连续的优先级顺序。Changing this also changes other conditional formats' priorities, to allow for a contiguous priority order. 使用负优先级从后开始。Use a negative priority to begin from the back. 优先级大于界限将获取并设置为最大值 (如果为负, 则为最小值) 优先级。Priorities greater than than bounds will get and set to the maximum (or minimum if negative) priority. 另请注意, 如果您更改优先级, 则必须在该新的优先级位置重新获取该对象的新副本 (如果要对其进行进一步的更改)。Also note that if you change the priority, you have to re-fetch a new copy of the object at that new priority location if you want to make further changes to it. 只读。Read-only.

[API 集: ExcelApi 1.6][ API set: ExcelApi 1.6 ]

stopIfTrue

对于集合中的每个项目: 如果满足此条件格式的条件, 则不会对该单元格生效优先级较低的格式。For EACH ITEM in the collection: If the conditions of this conditional format are met, no lower-priority formats shall take effect on that cell. 数值、icon sets 和 colorscales 中的 Null, 因为没有针对这些项的 StopIfTrue 的概念Null on databars, icon sets, and colorscales as there's no concept of StopIfTrue for these

[API 集: ExcelApi 1.6][ API set: ExcelApi 1.6 ]

textComparison

对于集合中的每一项: 如果当前条件格式是文本类型, 则返回特定的文本条件格式属性。For EACH ITEM in the collection: Returns the specific text conditional format properties if the current conditional format is a text type. 例如, 设置与单词 "Text" 相匹配的单元格的格式。For example to format cells matching the word "Text".

[API 集: ExcelApi 1.6][ API set: ExcelApi 1.6 ]

textComparisonOrNullObject

对于集合中的每一项: 如果当前条件格式是文本类型, 则返回特定的文本条件格式属性。For EACH ITEM in the collection: Returns the specific text conditional format properties if the current conditional format is a text type. 例如, 设置与单词 "Text" 相匹配的单元格的格式。For example to format cells matching the word "Text".

[API 集: ExcelApi 1.6][ API set: ExcelApi 1.6 ]

topBottom

对于集合中的每一项: 如果当前条件格式为 TopBottom 类型, 则返回顶部/底部条件格式属性。For EACH ITEM in the collection: Returns the Top/Bottom conditional format properties if the current conditional format is an TopBottom type. 例如, 设置前 10% 或前10个项目的格式。For example to format the top 10% or bottom 10 items.

[API 集: ExcelApi 1.6][ API set: ExcelApi 1.6 ]

topBottomOrNullObject

对于集合中的每一项: 如果当前条件格式为 TopBottom 类型, 则返回顶部/底部条件格式属性。For EACH ITEM in the collection: Returns the Top/Bottom conditional format properties if the current conditional format is an TopBottom type. 例如, 设置前 10% 或前10个项目的格式。For example to format the top 10% or bottom 10 items.

[API 集: ExcelApi 1.6][ API set: ExcelApi 1.6 ]

type

对于集合中的每一项: 一种条件格式。For EACH ITEM in the collection: A type of conditional format. 一次只能设置一个。Only one can be set at a time. 只读。Read-only.

[API 集: ExcelApi 1.6][ API set: ExcelApi 1.6 ]

属性详细信息

$all

$all?: boolean;

属性值

boolean

cellValue

对于集合中的每一项: 如果当前条件格式为 CellValue 类型, 则返回 cell 值条件格式属性。For EACH ITEM in the collection: Returns the cell value conditional format properties if the current conditional format is a CellValue type. 例如, 设置5到10之间的所有单元格的格式。For example to format all cells between 5 and 10.

[API 集: ExcelApi 1.6][ API set: ExcelApi 1.6 ]

cellValue?: Excel.Interfaces.CellValueConditionalFormatLoadOptions;

属性值

cellValueOrNullObject

对于集合中的每一项: 如果当前条件格式为 CellValue 类型, 则返回 cell 值条件格式属性。For EACH ITEM in the collection: Returns the cell value conditional format properties if the current conditional format is a CellValue type. 例如, 设置5到10之间的所有单元格的格式。For example to format all cells between 5 and 10.

[API 集: ExcelApi 1.6][ API set: ExcelApi 1.6 ]

cellValueOrNullObject?: Excel.Interfaces.CellValueConditionalFormatLoadOptions;

属性值

colorScale

对于集合中的每一项: 如果当前条件格式为色阶类型, 则返回色阶条件格式属性。For EACH ITEM in the collection: Returns the ColorScale conditional format properties if the current conditional format is an ColorScale type.

[API 集: ExcelApi 1.6][ API set: ExcelApi 1.6 ]

colorScale?: Excel.Interfaces.ColorScaleConditionalFormatLoadOptions;

属性值

colorScaleOrNullObject

对于集合中的每一项: 如果当前条件格式为色阶类型, 则返回色阶条件格式属性。For EACH ITEM in the collection: Returns the ColorScale conditional format properties if the current conditional format is an ColorScale type.

[API 集: ExcelApi 1.6][ API set: ExcelApi 1.6 ]

colorScaleOrNullObject?: Excel.Interfaces.ColorScaleConditionalFormatLoadOptions;

属性值

custom

对于集合中的每一项: 如果当前条件格式为自定义类型, 则返回自定义条件格式属性。For EACH ITEM in the collection: Returns the custom conditional format properties if the current conditional format is a custom type.

[API 集: ExcelApi 1.6][ API set: ExcelApi 1.6 ]

custom?: Excel.Interfaces.CustomConditionalFormatLoadOptions;

属性值

customOrNullObject

对于集合中的每一项: 如果当前条件格式为自定义类型, 则返回自定义条件格式属性。For EACH ITEM in the collection: Returns the custom conditional format properties if the current conditional format is a custom type.

[API 集: ExcelApi 1.6][ API set: ExcelApi 1.6 ]

customOrNullObject?: Excel.Interfaces.CustomConditionalFormatLoadOptions;

属性值

dataBar

对于集合中的每一项: 如果当前条件格式为数据栏, 则返回数据栏属性。For EACH ITEM in the collection: Returns the data bar properties if the current conditional format is a data bar.

[API 集: ExcelApi 1.6][ API set: ExcelApi 1.6 ]

dataBar?: Excel.Interfaces.DataBarConditionalFormatLoadOptions;

属性值

dataBarOrNullObject

对于集合中的每一项: 如果当前条件格式为数据栏, 则返回数据栏属性。For EACH ITEM in the collection: Returns the data bar properties if the current conditional format is a data bar.

[API 集: ExcelApi 1.6][ API set: ExcelApi 1.6 ]

dataBarOrNullObject?: Excel.Interfaces.DataBarConditionalFormatLoadOptions;

属性值

iconSet

对于集合中的每一项: 如果当前条件格式为 IconSet 类型, 则返回 IconSet 条件格式属性。For EACH ITEM in the collection: Returns the IconSet conditional format properties if the current conditional format is an IconSet type.

[API 集: ExcelApi 1.6][ API set: ExcelApi 1.6 ]

iconSet?: Excel.Interfaces.IconSetConditionalFormatLoadOptions;

属性值

iconSetOrNullObject

对于集合中的每一项: 如果当前条件格式为 IconSet 类型, 则返回 IconSet 条件格式属性。For EACH ITEM in the collection: Returns the IconSet conditional format properties if the current conditional format is an IconSet type.

[API 集: ExcelApi 1.6][ API set: ExcelApi 1.6 ]

iconSetOrNullObject?: Excel.Interfaces.IconSetConditionalFormatLoadOptions;

属性值

id

对于集合中的每个项目: 当前 ConditionalFormatCollection 中条件格式的优先级。For EACH ITEM in the collection: The Priority of the Conditional Format within the current ConditionalFormatCollection. 只读。Read-only.

[API 集: ExcelApi 1.6][ API set: ExcelApi 1.6 ]

id?: boolean;

属性值

boolean

preset

对于集合中的每一项: 返回预设条件条件格式。For EACH ITEM in the collection: Returns the preset criteria conditional format. 有关更多详细信息, 请参阅 PresetCriteriaConditionalFormat。See Excel.PresetCriteriaConditionalFormat for more details.

[API 集: ExcelApi 1.6][ API set: ExcelApi 1.6 ]

preset?: Excel.Interfaces.PresetCriteriaConditionalFormatLoadOptions;

属性值

presetOrNullObject

对于集合中的每一项: 返回预设条件条件格式。For EACH ITEM in the collection: Returns the preset criteria conditional format. 有关更多详细信息, 请参阅 PresetCriteriaConditionalFormat。See Excel.PresetCriteriaConditionalFormat for more details.

[API 集: ExcelApi 1.6][ API set: ExcelApi 1.6 ]

presetOrNullObject?: Excel.Interfaces.PresetCriteriaConditionalFormatLoadOptions;

属性值

priority

对于集合中的每一项: 条件格式集合中当前存在此条件格式的优先级 (或索引)。For EACH ITEM in the collection: The priority (or index) within the conditional format collection that this conditional format currently exists in. 更改此设置还会更改其他条件格式的优先级, 以允许进行连续的优先级顺序。Changing this also changes other conditional formats' priorities, to allow for a contiguous priority order. 使用负优先级从后开始。Use a negative priority to begin from the back. 优先级大于界限将获取并设置为最大值 (如果为负, 则为最小值) 优先级。Priorities greater than than bounds will get and set to the maximum (or minimum if negative) priority. 另请注意, 如果您更改优先级, 则必须在该新的优先级位置重新获取该对象的新副本 (如果要对其进行进一步的更改)。Also note that if you change the priority, you have to re-fetch a new copy of the object at that new priority location if you want to make further changes to it. 只读。Read-only.

[API 集: ExcelApi 1.6][ API set: ExcelApi 1.6 ]

priority?: boolean;

属性值

boolean

stopIfTrue

对于集合中的每个项目: 如果满足此条件格式的条件, 则不会对该单元格生效优先级较低的格式。For EACH ITEM in the collection: If the conditions of this conditional format are met, no lower-priority formats shall take effect on that cell. 数值、icon sets 和 colorscales 中的 Null, 因为没有针对这些项的 StopIfTrue 的概念Null on databars, icon sets, and colorscales as there's no concept of StopIfTrue for these

[API 集: ExcelApi 1.6][ API set: ExcelApi 1.6 ]

stopIfTrue?: boolean;

属性值

boolean

textComparison

对于集合中的每一项: 如果当前条件格式是文本类型, 则返回特定的文本条件格式属性。For EACH ITEM in the collection: Returns the specific text conditional format properties if the current conditional format is a text type. 例如, 设置与单词 "Text" 相匹配的单元格的格式。For example to format cells matching the word "Text".

[API 集: ExcelApi 1.6][ API set: ExcelApi 1.6 ]

textComparison?: Excel.Interfaces.TextConditionalFormatLoadOptions;

属性值

textComparisonOrNullObject

对于集合中的每一项: 如果当前条件格式是文本类型, 则返回特定的文本条件格式属性。For EACH ITEM in the collection: Returns the specific text conditional format properties if the current conditional format is a text type. 例如, 设置与单词 "Text" 相匹配的单元格的格式。For example to format cells matching the word "Text".

[API 集: ExcelApi 1.6][ API set: ExcelApi 1.6 ]

textComparisonOrNullObject?: Excel.Interfaces.TextConditionalFormatLoadOptions;

属性值

topBottom

对于集合中的每一项: 如果当前条件格式为 TopBottom 类型, 则返回顶部/底部条件格式属性。For EACH ITEM in the collection: Returns the Top/Bottom conditional format properties if the current conditional format is an TopBottom type. 例如, 设置前 10% 或前10个项目的格式。For example to format the top 10% or bottom 10 items.

[API 集: ExcelApi 1.6][ API set: ExcelApi 1.6 ]

topBottom?: Excel.Interfaces.TopBottomConditionalFormatLoadOptions;

属性值

topBottomOrNullObject

对于集合中的每一项: 如果当前条件格式为 TopBottom 类型, 则返回顶部/底部条件格式属性。For EACH ITEM in the collection: Returns the Top/Bottom conditional format properties if the current conditional format is an TopBottom type. 例如, 设置前 10% 或前10个项目的格式。For example to format the top 10% or bottom 10 items.

[API 集: ExcelApi 1.6][ API set: ExcelApi 1.6 ]

topBottomOrNullObject?: Excel.Interfaces.TopBottomConditionalFormatLoadOptions;

属性值

type

对于集合中的每一项: 一种条件格式。For EACH ITEM in the collection: A type of conditional format. 一次只能设置一个。Only one can be set at a time. 只读。Read-only.

[API 集: ExcelApi 1.6][ API set: ExcelApi 1.6 ]

type?: boolean;

属性值

boolean