AutoFiltersCollection
CustomFilter Method (Int32, FilterOperatorType, Object)
|
Filters a list with a custom 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(
int columnIndex,
FilterOperatorType operatorType,
Object criteria
)
Public Sub CustomFilter (
columnIndex As Integer,
operatorType As FilterOperatorType,
criteria As Object
)
public:
void CustomFilter(
int columnIndex,
FilterOperatorType operatorType,
Object^ criteria
)
member CustomFilter :
columnIndex : int *
operatorType : FilterOperatorType *
criteria : Object -> unit
Parameters
-
columnIndex
-
Type:
System
Int32
The column field on which you want to base the filter . for exapmle: sheet.AutoFilters[0]
-
operatorType
-
Type:
Spire.Xls.Core.Spreadsheet.AutoFilter
FilterOperatorType
The filter operator type
-
criteria
-
Type:
System
Object
The custom criteria
See Also