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

XL.Table.RemoveFilter

Removes the AutoFilter from the sheet (only for xlsx files).

Component Version macOS Windows Linux Server iOS SDK
XL 16.3 ✅ Yes ✅ Yes ✅ Yes ✅ Yes ✅ Yes
MBS( "XL.Table.RemoveFilter"; 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 OK or error.

Description

Removes the AutoFilter from the sheet (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.IsAutoFilter - XL.Table.SetColumnName