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
)
Public Sub QuickFilter (
columnIndex As Integer,
criteria As String
)
public:
void QuickFilter(
int columnIndex,
String^ criteria
)
member QuickFilter :
columnIndex : int *
criteria : string -> unit
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