GrapeCity.Documents.Excel.IPivotFilters

Interface IPivotFilters

Namespace

GrapeCity.Documents.Excel

Assembly

GcDocs.Excel.dll

Represents a collection of all the pivot filters in the pivot field.

public interface IPivotFilters : IEnumerable<IPivotFilter>, IEnumerable

Inherited Members

System.Collections.Generic.IEnumerable<GrapeCity.Documents.Excel.IPivotFilter>.GetEnumerator()

Properties

Count

Gets the number of pivot filters in the collection.

int Count { get; }

Property Value

int

this[int]

Gets the pivot filter at the specified index.

IPivotFilter this[int index] { get; }

Parameters

index int

The zero-based index of the pivot filter to get.

Property Value

IPivotFilter

The pivot filter at the specified index.

Methods

Add(PivotFilterType, object, object, PivotFilterOptions)

Adds a new filter to the PivotFilters collection.

IPivotFilter Add(PivotFilterType type, object value1 = null, object value2 = null, PivotFilterOptions options = null)

Parameters

type PivotFilterType

The type of filter.

value1 object

The first value for the filter (optional).

value2 object

The second value for the filter (optional).

options PivotFilterOptions

Additional settings for the filter (optional).

Returns

IPivotFilter

The added pivot filter.