ApiFilter

Represents the ApiFilter class.

Properties

Name	Type	Description
Criteria1	string | string[] | number | XlDynamicFilterCriteria | null	Returns the first criteria associated with the filter.
Criteria2	string | null	Returns the second criteria associated with the filter (used with xlAnd/xlOr).
On	boolean	Indicates whether any filter is applied to this column.
Operator	XlAutoFilterOperator | null	Returns the operator used for the filter on this column.
Parent	ApiAutoFilter	Returns the parent filters collection for this filter column.

Methods

Method	Returns	Description
GetCriteria1	string | string[] | number | XlDynamicFilterCriteria | null	Returns the first criteria associated with the filter for this column.
GetCriteria2	string | null	Returns the second criteria associated with the filter for this column.
GetOn	boolean	Indicates whether any filter is applied on this column.
GetOperator	XlAutoFilterOperator | null	Returns the operator used for the filter on this column.
GetParent	ApiAutoFilter	Returns the parent filters collection for this filter column.