Topics   All   MacOS (Only)   Windows (Only)   Linux (Only, Not)   iOS (Only, Not)  
Components   Crossplatform Mac & Win   Server   Client   Old   Deprecated   Guides   Examples   Videos
New in version: 10.1   10.2   10.3   10.4   10.5   11.0   11.1   11.2   11.3   11.4    Statistic    FMM    Blog  

XL.Sheet.AutoFilter.GetTop10

Gets the number of top or bottom items.

Component Version macOS Windows Linux Server iOS SDK
XL 7.3 ✅ Yes ✅ Yes ✅ Yes ✅ Yes ✅ Yes
MBS( "XL.Sheet.AutoFilter.GetTop10"; bookRef; sheetIndex; FilterColumnIndex; Selector )   More

Parameters

Parameter Description Example
bookRef The reference to the workbook. Please use XL.LoadBook to load a file. $ref
sheetIndex The index of the sheet. This number ranges from 0 to XL.Book.SheetCount-1. 0
FilterColumnIndex The column index of the filter.
Range from 0 to XL.Sheet.AutoFilter.ColumnSize-1.
$FilterColumn
Selector Which value to return.
Can be value for number of items;
top to get top items if 1 otherwise bottom items if 0;
percent for using percent instead of number items.
"Value"

Result

Returns value or error.

Description

Gets the number of top or bottom items.

See also

Created 1st July 2017, last changed 1st July 2017


XL.Sheet.AutoFilter.GetSortRange - XL.Sheet.AutoFilter.SetCustomFilter

Feedback: Report problem or ask question.