AutoFiltersCollection
FilterTop10 Method (IAutoFilter, 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(
IAutoFilter column,
bool isTop,
bool isPercent,
int itemCount
)
Public Sub FilterTop10 (
column As IAutoFilter,
isTop As Boolean,
isPercent As Boolean,
itemCount As Integer
)
public:
void FilterTop10(
IAutoFilter^ column,
bool isTop,
bool isPercent,
int itemCount
)
member FilterTop10 :
column : IAutoFilter *
isTop : bool *
isPercent : bool *
itemCount : int -> unit
Parameters
-
column
-
Type:
Spire.Xls.Core
IAutoFilter
The column field on which you want to base the filter. for exapmle: sheet.AutoFilters[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