Worksheet.FilterMode Property
Gets a value that indicates whether the worksheet is actively filtering data.
Namespace: Microsoft.Office.Tools.Excel
Assemblies: Microsoft.Office.Tools.Excel (in Microsoft.Office.Tools.Excel.dll)
Microsoft.Office.Tools.Excel.v4.0.Utilities (in Microsoft.Office.Tools.Excel.v4.0.Utilities.dll)
Syntax
'Declaration
ReadOnly Property FilterMode As Boolean
bool FilterMode { get; }
Property Value
Type: System.Boolean
true if the worksheet is actively filtering data; otherwise, false.
Remarks
To determine whether filtering is currently enabled (that is, whether the filter drop-down arrows are displayed on the worksheet), use the AutoFilterMode property.
To enable filtering and create a filtered list, use the AutoFilter method of a Range object, or use the AutoFilter method of a NamedRange object.
This property is true if the worksheet contains a filtered list in which there are hidden rows.
.NET Framework Security
- Full trust for the immediate caller. This member cannot be used by partially trusted code. For more information, see Using Libraries from Partially Trusted Code.