Excel.FilterCriteria interface

表示应用于列的筛选条件。Represents the filtering criteria applied to a column.

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

属性

color

用于筛选单元格的 HTML 颜色字符串。The HTML color string used to filter cells. 与“cellColor”和“fontColor”筛选一起使用。Used with "cellColor" and "fontColor" filtering.

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

criterion1

第一个条件用于筛选数据。The first criterion used to filter data. 在“自定义”筛选中用作运算符。Used as an operator in the case of "custom" filtering. 例如 "For example ">50 "的数字大于50或" = * s "(表示以" s "结尾的值)。50" for number greater than 50 or "=*s" for values ending in "s".

在 top/底端项目/百分比的情况下用作数字。Used as a number in the case of top/bottom items/percents. 例如,E.g. 如果将 "开启" 设置为 "topItems", 则返回前5项的 "5""5" for the top 5 items if filterOn is set to "topItems"

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

criterion2

第二个条件用于筛选数据。The second criterion used to filter data. 在“自定义”筛选中仅用作运算符。Only used as an operator in the case of "custom" filtering.

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

dynamicCriteria

Excel.DynamicFilterCriteria 集中的动态条件将应用于此列。The dynamic criteria from the Excel.DynamicFilterCriteria set to apply on this column. 与“动态”筛选一起使用。Used with "dynamic" filtering.

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

filterOn

筛选器使用的属性,用于确定是否应将值保持为可见时。The property used by the filter to determine whether the values should stay visible.

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

icon

用于筛选单元格的图标。The icon used to filter cells. 与“图标”筛选一起使用。Used with "icon" filtering.

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

operator

使用“自定义”筛选时,用于组合条件 1 和 2 的运算符。The operator used to combine criterion 1 and 2 when using "custom" filtering.

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

subField

筛选器使用该属性对 richvalue 执行丰富的筛选。The property used by the filter to do rich filter on richvalues.

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

values

一组用于“values”筛选器的值。The set of values to be used as part of "values" filtering.

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

属性详细信息

color

用于筛选单元格的 HTML 颜色字符串。The HTML color string used to filter cells. 与“cellColor”和“fontColor”筛选一起使用。Used with "cellColor" and "fontColor" filtering.

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

color?: string;

属性值

string

criterion1

第一个条件用于筛选数据。The first criterion used to filter data. 在“自定义”筛选中用作运算符。Used as an operator in the case of "custom" filtering. 例如 "For example ">50 "的数字大于50或" = * s "(表示以" s "结尾的值)。50" for number greater than 50 or "=*s" for values ending in "s".

在 top/底端项目/百分比的情况下用作数字。Used as a number in the case of top/bottom items/percents. 例如,E.g. 如果将 "开启" 设置为 "topItems", 则返回前5项的 "5""5" for the top 5 items if filterOn is set to "topItems"

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

criterion1?: string;

属性值

string

criterion2

第二个条件用于筛选数据。The second criterion used to filter data. 在“自定义”筛选中仅用作运算符。Only used as an operator in the case of "custom" filtering.

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

criterion2?: string;

属性值

string

dynamicCriteria

Excel.DynamicFilterCriteria 集中的动态条件将应用于此列。The dynamic criteria from the Excel.DynamicFilterCriteria set to apply on this column. 与“动态”筛选一起使用。Used with "dynamic" filtering.

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

dynamicCriteria?: Excel.DynamicFilterCriteria | "Unknown" | "AboveAverage" | "AllDatesInPeriodApril" | "AllDatesInPeriodAugust" | "AllDatesInPeriodDecember" | "AllDatesInPeriodFebruray" | "AllDatesInPeriodJanuary" | "AllDatesInPeriodJuly" | "AllDatesInPeriodJune" | "AllDatesInPeriodMarch" | "AllDatesInPeriodMay" | "AllDatesInPeriodNovember" | "AllDatesInPeriodOctober" | "AllDatesInPeriodQuarter1" | "AllDatesInPeriodQuarter2" | "AllDatesInPeriodQuarter3" | "AllDatesInPeriodQuarter4" | "AllDatesInPeriodSeptember" | "BelowAverage" | "LastMonth" | "LastQuarter" | "LastWeek" | "LastYear" | "NextMonth" | "NextQuarter" | "NextWeek" | "NextYear" | "ThisMonth" | "ThisQuarter" | "ThisWeek" | "ThisYear" | "Today" | "Tomorrow" | "YearToDate" | "Yesterday";

属性值

Excel.DynamicFilterCriteria | "Unknown" | "AboveAverage" | "AllDatesInPeriodApril" | "AllDatesInPeriodAugust" | "AllDatesInPeriodDecember" | "AllDatesInPeriodFebruray" | "AllDatesInPeriodJanuary" | "AllDatesInPeriodJuly" | "AllDatesInPeriodJune" | "AllDatesInPeriodMarch" | "AllDatesInPeriodMay" | "AllDatesInPeriodNovember" | "AllDatesInPeriodOctober" | "AllDatesInPeriodQuarter1" | "AllDatesInPeriodQuarter2" | "AllDatesInPeriodQuarter3" | "AllDatesInPeriodQuarter4" | "AllDatesInPeriodSeptember" | "BelowAverage" | "LastMonth" | "LastQuarter" | "LastWeek" | "LastYear" | "NextMonth" | "NextQuarter" | "NextWeek" | "NextYear" | "ThisMonth" | "ThisQuarter" | "ThisWeek" | "ThisYear" | "Today" | "Tomorrow" | "YearToDate" | "Yesterday"

filterOn

筛选器使用的属性,用于确定是否应将值保持为可见时。The property used by the filter to determine whether the values should stay visible.

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

filterOn: Excel.FilterOn | "BottomItems" | "BottomPercent" | "CellColor" | "Dynamic" | "FontColor" | "Values" | "TopItems" | "TopPercent" | "Icon" | "Custom";

属性值

Excel.FilterOn | "BottomItems" | "BottomPercent" | "CellColor" | "Dynamic" | "FontColor" | "Values" | "TopItems" | "TopPercent" | "Icon" | "Custom"

icon

用于筛选单元格的图标。The icon used to filter cells. 与“图标”筛选一起使用。Used with "icon" filtering.

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

icon?: Excel.Icon;

属性值

operator

使用“自定义”筛选时,用于组合条件 1 和 2 的运算符。The operator used to combine criterion 1 and 2 when using "custom" filtering.

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

operator?: Excel.FilterOperator | "And" | "Or";

属性值

Excel.FilterOperator | "And" | "Or"

subField

筛选器使用该属性对 richvalue 执行丰富的筛选。The property used by the filter to do rich filter on richvalues.

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

subField?: string;

属性值

string

values

一组用于“values”筛选器的值。The set of values to be used as part of "values" filtering.

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

values?: Array<string | FilterDatetime>;

属性值

Array<string | FilterDatetime>