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