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

XL.Table.IsAutoFilter

Returns true if the AutoFilter already exists (only for xlsx files).

Component Version macOS Windows Linux Server iOS SDK
XL 16.3 ✅ Yes ✅ Yes ✅ Yes ✅ Yes ✅ Yes
MBS( "XL.Table.IsAutoFilter"; BookRef; SheetIndex; TableIndex )   More

Parameters

Parameter Description Example
BookRef The reference number for the workbook. $ref
SheetIndex The index of the sheet. This number ranges from 0 to XL.Book.SheetCount-1. 0
TableIndex The name of the table or the zero based index. 0

Result

Returns 1, 0 or error.

Description

Returns true if the AutoFilter already exists (only for xlsx files).

See also

Release notes

  • Version 16.3
    • Added XL.Table.IsAutoFilter and XL.Table.RemoveFilter functions.

This function checks for a license.

Created 21st May 2026, last changed 21st May 2026


XL.Table.GetStyle - XL.Table.RemoveFilter