AutoFiltersCollection
FilterTop10 Method (Int32, Boolean, Boolean, Int32)
|
Filter the top 10 item in the list
Namespace:
Spire.Xls.Collections
Assembly:
Spire.XLS (in Spire.XLS.dll) Version: 15.4.0.0 (15.4.0.5046)
Syntax
public void FilterTop10(
int filterColumnIndex,
bool isTop,
bool isPercent,
int itemCount
)
Public Sub FilterTop10 (
filterColumnIndex As Integer,
isTop As Boolean,
isPercent As Boolean,
itemCount As Integer
)
public:
void FilterTop10(
int filterColumnIndex,
bool isTop,
bool isPercent,
int itemCount
)
member FilterTop10 :
filterColumnIndex : int *
isTop : bool *
isPercent : bool *
itemCount : int -> unit
Parameters
-
filterColumnIndex
-
Type:
System
Int32
The column field index on which you want to base the filter (from the left of the list; the leftmost field is field 0).
-
isTop
-
Type:
System
Boolean
Indicates whether filter from top or bottom
-
isPercent
-
Type:
System
Boolean
Indicates whether the items is percent or count
-
itemCount
-
Type:
System
Int32
The item count
See Also