PivotFilters PivotFilters PivotFilters Interface

Definition

The PivotFilters object is a collection of PivotFilter objects.

public interface class PivotFilters : System::Collections::IEnumerable
[System.Runtime.InteropServices.Guid("00024484-0000-0000-C000-000000000046")]
[System.Runtime.InteropServices.InterfaceType(2)]
public interface PivotFilters : System.Collections.IEnumerable
Public Interface PivotFilters
Implements IEnumerable
Attributes
Implements

Remarks

The PivotFilters collection contains properties and methods to add new filters, count the number of existing filters in the collection, and reference specific PivotFilter objects.

Properties

_Default[Object] _Default[Object] _Default[Object]
Application Application Application

When used without an object qualifier, this property returns an _Application object that represents the Microsoft Office Excel application. When used with an object qualifier, this property returns an Application object that represents the creator of the specified object. Read-only.

Count Count Count

Returns the number of items in the PivotFilters collection. Read-only.

Creator Creator Creator

Returns a 32-bit Integer that indicates the application in which this object was created. Read-only.

Item[Object] Item[Object] Item[Object]

Returns a specific element of the PivotFilters collection object by its position in the collection. Read-only.

Parent Parent Parent

Returns the parent for the specified PivotFilters object. Read-only.

Methods

Add(XlPivotFilterType, Object, Object, Object, Object, Object, Object, Object) Add(XlPivotFilterType, Object, Object, Object, Object, Object, Object, Object) Add(XlPivotFilterType, Object, Object, Object, Object, Object, Object, Object)

This object, member, or enumeration is deprecated and is not intended to be used in your code.

Add2(XlPivotFilterType, Object, Object, Object, Object, Object, Object, Object, Object) Add2(XlPivotFilterType, Object, Object, Object, Object, Object, Object, Object, Object) Add2(XlPivotFilterType, Object, Object, Object, Object, Object, Object, Object, Object)

Adds new filters to the PivotFilters collection.

GetEnumerator() GetEnumerator() GetEnumerator()

Applies to