CubeFields CubeFields CubeFields Interface


A collection of all CubeField objects in a PivotTable report that is based on an OLAP cube.

public interface class CubeFields : System::Collections::IEnumerable
public interface CubeFields : System.Collections.IEnumerable
Public Interface CubeFields
Implements IEnumerable


Each CubeField object represents a hierarchy or measure field from the cube.

Use the CubeFields property to return the CubeFields collection.

Use CubeFields(index), where index is the cube field’s index number, to return a single CubeField object.


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

Reserved for internal use.

Application Application Application

Returns an Application object that represents the Microsoft Excel application.

Count Count Count

Returns the number of objects in the collection.

Creator Creator Creator

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

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

Returns a single object from a collection.

Parent Parent Parent

Returns the parent object for the specified object.


AddSet(String, String) AddSet(String, String) AddSet(String, String)

Adds a new CubeField object to the CubeFields collection.

GetEnumerator() GetEnumerator() GetEnumerator()
GetMeasure(Object, XlConsolidationFunction, Object) GetMeasure(Object, XlConsolidationFunction, Object) GetMeasure(Object, XlConsolidationFunction, Object)

Given an attribute hierarchy, returns an implicit measure for the given function that corresponds to this attribute. If an “implicit measure” does not exist, a new implicit measure is created and added to the CubeFields collection.

Applies to