Excel.SortField interface

表示排序操作中的条件。Represents a condition in a sorting operation.

[API 集: ExcelApi 1.2][ API set: ExcelApi 1.2 ]

属性

ascending

表示是否执行升序排序。Represents whether the sorting is done in an ascending fashion.

[API 集: ExcelApi 1.2][ API set: ExcelApi 1.2 ]

color

表示按字体或单元格颜色进行排序时,条件的目标颜色。Represents the color that is the target of the condition if the sorting is on font or cell color.

[API 集: ExcelApi 1.2][ API set: ExcelApi 1.2 ]

dataOption

表示此字段的其他排序选项。Represents additional sorting options for this field.

[API 集: ExcelApi 1.2][ API set: ExcelApi 1.2 ]

icon

表示对单元格图标进行排序时,条件的目标图标。Represents the icon that is the target of the condition if the sorting is on the cell's icon.

[API 集: ExcelApi 1.2][ API set: ExcelApi 1.2 ]

key

表示条件所在的列(或行,具体取决于排序方向)。表示与第一列(或行)的偏移量。Represents the column (or row, depending on the sort orientation) that the condition is on. Represented as an offset from the first column (or row).

[API 集: ExcelApi 1.2][ API set: ExcelApi 1.2 ]

sortOn

表示此条件的排序类型。Represents the type of sorting of this condition.

[API 集: ExcelApi 1.2][ API set: ExcelApi 1.2 ]

subField

表示子字段,它是要排序的复合值的目标属性名称。Represents the subfield that is the target property name of a rich value to sort on.

[API 集: ExcelApi 1.9][ API set: ExcelApi 1.9 ]

属性详细信息

ascending

表示是否执行升序排序。Represents whether the sorting is done in an ascending fashion.

[API 集: ExcelApi 1.2][ API set: ExcelApi 1.2 ]

ascending?: boolean;

属性值

boolean

color

表示按字体或单元格颜色进行排序时,条件的目标颜色。Represents the color that is the target of the condition if the sorting is on font or cell color.

[API 集: ExcelApi 1.2][ API set: ExcelApi 1.2 ]

color?: string;

属性值

string

dataOption

表示此字段的其他排序选项。Represents additional sorting options for this field.

[API 集: ExcelApi 1.2][ API set: ExcelApi 1.2 ]

dataOption?: Excel.SortDataOption | "Normal" | "TextAsNumber";

属性值

Excel.SortDataOption | "Normal" | "TextAsNumber"

icon

表示对单元格图标进行排序时,条件的目标图标。Represents the icon that is the target of the condition if the sorting is on the cell's icon.

[API 集: ExcelApi 1.2][ API set: ExcelApi 1.2 ]

icon?: Excel.Icon;

属性值

key

表示条件所在的列(或行,具体取决于排序方向)。表示与第一列(或行)的偏移量。Represents the column (or row, depending on the sort orientation) that the condition is on. Represented as an offset from the first column (or row).

[API 集: ExcelApi 1.2][ API set: ExcelApi 1.2 ]

key: number;

属性值

number

sortOn

表示此条件的排序类型。Represents the type of sorting of this condition.

[API 集: ExcelApi 1.2][ API set: ExcelApi 1.2 ]

sortOn?: Excel.SortOn | "Value" | "CellColor" | "FontColor" | "Icon";

属性值

Excel.SortOn | "Value" | "CellColor" | "FontColor" | "Icon"

subField

表示子字段,它是要排序的复合值的目标属性名称。Represents the subfield that is the target property name of a rich value to sort on.

[API 集: ExcelApi 1.9][ API set: ExcelApi 1.9 ]

subField?: string;

属性值

string