Click or drag to resize

AutoFiltersCollection QuickFilter Method (Int32, String)

Filters a list with specified criteria.

Namespace: Spire.Xls.Collections
Assembly: Spire.XLS (in Spire.XLS.dll) Version: 15.4.0.0 (15.4.0.5046)
Syntax
public void QuickFilter(
	int columnIndex,
	string criteria
)

Parameters

columnIndex
Type: System Int32
The column field on which you want to base the filter . for exapmle: sheet.AutoFilters[0]
criteria
Type: System String
The specified criteria (a string; for example, "hello").
Remarks
will remove all other filter setting on this field as Ms Excel 97-2003.
See Also