AutoFiltersCollection
CustomFilter Method (FilterColumn, FilterOperatorType, Object)
|
Applies a custom filter to a specified column using the given operator and criteria.
Namespace:
Spire.Xls.Collections
Assembly:
Spire.XLS (in Spire.XLS.dll) Version: 15.4.0.0 (15.4.0.5046)
Syntax
public void CustomFilter(
FilterColumn column,
FilterOperatorType operatorType,
Object criteria
)
Public Sub CustomFilter (
column As FilterColumn,
operatorType As FilterOperatorType,
criteria As Object
)
public:
void CustomFilter(
FilterColumn^ column,
FilterOperatorType operatorType,
Object^ criteria
)
member CustomFilter :
column : FilterColumn *
operatorType : FilterOperatorType *
criteria : Object -> unit
Parameters
-
column
-
Type:
Spire.Xls.Core.Spreadsheet.AutoFilter
FilterColumn
The column to which the filter is applied.
-
operatorType
-
Type:
Spire.Xls.Core.Spreadsheet.AutoFilter
FilterOperatorType
The type of operator to use for filtering.
-
criteria
-
Type:
System
Object
The criteria to use for filtering.
See Also