Excel.Interfaces.AutoFilterData interface

描述通过调用 "toJSON ()" 返回的数据的接口。An interface describing the data returned by calling "autoFilter.toJSON()".

属性

criteria

一个包含自动筛选区域中的所有筛选条件的数组。An array that holds all the filter criteria in the autofiltered range. 只读。Read-Only.

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

enabled

指示是否启用了自动筛选。Indicates if the AutoFilter is enabled or not. 只读。Read-Only.

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

isDataFiltered

指示自动筛选是否具有筛选条件。Indicates if the AutoFilter has filter criteria. 只读。Read-Only.

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

属性详细信息

criteria

一个包含自动筛选区域中的所有筛选条件的数组。An array that holds all the filter criteria in the autofiltered range. 只读。Read-Only.

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

criteria?: Excel.FilterCriteria[];

属性值

Excel.FilterCriteria[]

enabled

指示是否启用了自动筛选。Indicates if the AutoFilter is enabled or not. 只读。Read-Only.

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

enabled?: boolean;

属性值

boolean

isDataFiltered

指示自动筛选是否具有筛选条件。Indicates if the AutoFilter has filter criteria. 只读。Read-Only.

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

isDataFiltered?: boolean;

属性值

boolean