Click or drag to resize

AutoFiltersCollection CustomFilter Method (Int32, FilterOperatorType, Object, Boolean, FilterOperatorType, Object)

Filters a list with custom criterias.

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 operatorType1,
	Object criteria1,
	bool isAnd,
	FilterOperatorType operatorType2,
	Object criteria2
)

Parameters

columnIndex
Type: System Int32
The column field on which you want to base the filter. for exapmle: sheet.AutoFilters[0]
operatorType1
Type: Spire.Xls.Core.Spreadsheet.AutoFilter FilterOperatorType
The first filter operator type
criteria1
Type: System Object
The first custom criteria
isAnd
Type: System Boolean
operatorType2
Type: Spire.Xls.Core.Spreadsheet.AutoFilter FilterOperatorType
The second filter operator type
criteria2
Type: System Object
The second custom criteria
See Also