Excel.ConditionalTopBottomRule interface

表示顶部/底部条件格式的规则。Represents the rule of the top/bottom conditional format.

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

属性

rank

1 和 1000 之间的数字排名或 1 和 100 之间的百分比排名。The rank between 1 and 1000 for numeric ranks or 1 and 100 for percent ranks.

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

type

根据顶部或底部排名设置值的格式。Format values based on the top or bottom rank.

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

属性详细信息

rank

1 和 1000 之间的数字排名或 1 和 100 之间的百分比排名。The rank between 1 and 1000 for numeric ranks or 1 and 100 for percent ranks.

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

rank: number;

属性值

number

type

根据顶部或底部排名设置值的格式。Format values based on the top or bottom rank.

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

type: Excel.ConditionalTopBottomCriterionType | "Invalid" | "TopItems" | "TopPercent" | "BottomItems" | "BottomPercent";

属性值

Excel.ConditionalTopBottomCriterionType | "Invalid" | "TopItems" | "TopPercent" | "BottomItems" | "BottomPercent"