Components All New MacOS Windows Linux iOS
Examples Mac & Win Server Client Guides Statistic FMM Blog Deprecated Old

XL.Sheet.AutoFilter

Initializes the AutoFilter.

Component Version macOS Windows Linux Server iOS SDK
XL 7.2 ✅ Yes ✅ Yes ✅ Yes ✅ Yes ✅ Yes
MBS( "XL.Sheet.AutoFilter"; bookRef; sheetIndex )   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

Result

Returns OK or error.

Description

Initializes the AutoFilter.
Creates it if it doesn't exist.

Examples

Create auto filter:

Set Variable [ $r; Value: MBS( "XL.Sheet.AutoFilter"; $book; $sheet) ]
Set Variable [ $r; Value: MBS( "XL.Sheet.AutoFilter.SetRef"; $book; $sheet; 2; 10; 1; 4) ]
Set Variable [ $r; Value: MBS( "XL.Sheet.AutoFilter.AddFilter"; $book; $sheet; 0; "Japan") ]
Set Variable [ $r; Value: MBS( "XL.Sheet.AutoFilter.AddFilter"; $book; $sheet; 0; "USA") ]
Set Variable [ $r; Value: MBS( "XL.Sheet.AutoFilter.AddFilter"; $book; $sheet; 0; "Switzerland") ]
Set Variable [ $r; Value: MBS( "XL.Sheet.ApplyFilter"; $book; $sheet) ]

See also

Release notes

Example Databases

Blog Entries

This function checks for a license.

Created 22nd April 2017, last changed 13th March 2020


XL.Sheet.AreCellsEmpty - XL.Sheet.AutoFilter.AddFilter

💬 Ask a question or report a problem