共用方式為


Worksheet.AutoFilter Property

Definition

Gets a AutoFilter that provides information about filtered lists on the worksheet if filtering is enabled. Gets null if filtering is off.

public:
 property Microsoft::Office::Interop::Excel::AutoFilter ^ AutoFilter { Microsoft::Office::Interop::Excel::AutoFilter ^ get(); };
public Microsoft.Office.Interop.Excel.AutoFilter AutoFilter { get; }
member this.AutoFilter : Microsoft.Office.Interop.Excel.AutoFilter
Public ReadOnly Property AutoFilter As AutoFilter

Property Value

A AutoFilter that provides information about filtered lists on the worksheet if filtering is enabled; otherwise, null.

Remarks

To programmatically enable filtering, use the AutoFilter method of the Range object or the AutoFilter method of a NamedRange object.

Applies to