Spire.XLS API

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

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

AutoFiltersCollection AddLanguageSpecificTextSet("LST23C4203D_0?cpp=::|nu=."); FilterTop10 Method (Int32, Boolean, Boolean, Int32)