Spire.XLS API

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

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

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