AutoFilter Interface

Reference

Definition

Namespace:: Microsoft.Office.Interop.Excel

Assembly:: Microsoft.Office.Interop.Excel.dll

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

Represents autofiltering for the specified worksheet.

public interface class AutoFilter

[System.Runtime.InteropServices.Guid("00024432-0000-0000-C000-000000000046")]
[System.Runtime.InteropServices.InterfaceType(2)]
public interface AutoFilter

Public Interface AutoFilter

Attributes: GuidAttribute InterfaceTypeAttribute

Remarks

Use the AutoFilter property to return the AutoFilter object. Use the Filters property to return a collection of individual column filters. Use the Range property to return the Range object that represents the entire filtered range.

To create an AutoFilter object for a worksheet, you must turn autofiltering on for a range on the worksheet either manually or using the AutoFilter(Object, Object, XlAutoFilterOperator, Object, Object) method of the Range object.

Properties

Application	Returns an Application object that represents the creator of the specified object (you can use this property with an OLE Automation object to return the application of that object). Read-only.
Creator	Returns a 32-bit integer that indicates the application in which this object was created. If the object was created in Microsoft Excel, this property returns the string XCEL, which is equivalent to the hexadecimal number 5843454C. Read-only XlCreator.
FilterMode	Returns True if the worksheet is in the AutoFilter filter mode. Read-only Boolean.
Filters	Returns a Filters collection that represents all the filters in an autofiltered range. Read-only.
Parent	Returns the parent object for the specified object. Read-only.
Range	Returns a Range object that represents the range to which the specified AutoFilter applies.
Sort	Gets the sort column or columns, and sort order for the AutoFilter collection.

Methods

ApplyFilter()	Applies the specified AutoFilterobject.
ShowAllData()	Displays all the data returned by the AutoFilterobject.

Applies to