Back to Devexpress

PivotPageFieldCollection Interface

officefileapi-devexpress-dot-spreadsheet-caa013a0.md

latest2.9 KB
Original Source

PivotPageFieldCollection Interface

Represents a collection of fields located in the report filter area of a pivot table.

Namespace : DevExpress.Spreadsheet

Assembly : DevExpress.Spreadsheet.v25.2.Core.dll

NuGet Package : DevExpress.Spreadsheet.Core

Declaration

csharp
public interface PivotPageFieldCollection :
    ISimpleCollection<PivotPageField>,
    IEnumerable<PivotPageField>,
    IEnumerable,
    ICollection
vb
Public Interface PivotPageFieldCollection
    Inherits ISimpleCollection(Of PivotPageField),
             IEnumerable(Of PivotPageField),
             IEnumerable,
             ICollection

The following members return PivotPageFieldCollection objects:

Remarks

The PivotPageFieldCollection object stores all page fields added to a PivotTable report. Use the PivotTable.PageFields property to access this collection. The PivotPageFieldCollection.Item property enables you to get an individual page field by its name or index in the collection.

To add a page field to the pivot table, use the PivotPageFieldCollection.Add or PivotPageFieldCollection.Insert method. To remove a page field from the PivotTable report, use the PivotPageFieldCollection.Remove or PivotPageFieldCollection.RemoveAt method.

See Also

PivotPageFieldCollection Members

Pivot Tables in Spreadsheet Documents

Pivot Table Structure

WinForms Spreadsheet Control Examples

DevExpress.Spreadsheet Namespace