SoftArtisans ExcelWriter Guide

The PivotFields Collection (IPivotFields)

New

* The PivotFields collection is not available in ExcelWriterSE, ExcelWriterLE, or ExcelWriterFree.

The IPivotFields object represents the collection of pivot fields in a PivotTable. A pivot field is a category of data that is derived from a field in the PivotTable's source data. Use the property IPivotTable.Fields to access the IPivotFields collection, for example:

[VBScript]
'--- The Fields collection is populated automatically
'--- based on the range of data passed to the CreatePivotTable 
'--- method.
Set fldProduct = pvtTable.Fields("Product")

IPivotFields Properties

Count

Signature

[VBScript]
Property Count As Long (read-only)

Description

Count returns the number of IPivotFields in the IPivotFields collection.

Top

Item

Signature

[VBScript]
Property Item(Table As Variant) As IPivotField (read-only)

Description

Item represents a single Pivot field in a IPivotFields collection. In VBScript, Item is the default property of the IPivotFields object, so IPivotFields(1) is equivalent to IPivotFields.Item(1). You can reference an Item either by number or by name.

In C#, Item is the indexer for the IPivotFields class.

Top