Click or drag to resize

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
)

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