CubeField.AddMemberPropertyField Method

Adds a member property field to the display for the cube field.

Namespace:  Microsoft.Office.Interop.Excel
Assembly:  Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)

Syntax

'Declaration
Sub AddMemberPropertyField ( _
    Property As String, _
    PropertyOrder As Object _
)
'Usage
Dim instance As CubeField
Dim Property As String
Dim PropertyOrder As Object

instance.AddMemberPropertyField(Property, _
    PropertyOrder)

void AddMemberPropertyField(
    string Property,
    Object PropertyOrder
)

Parameters

• Property
  Type: System.String

  Required String. The unique name of the member property. For balanced hierarchies, a unique name can be created by appending the "quoted" member property name to the unique name of the level the member property is associated with. For unbalanced hierarchies, a unique name can be created by appending the "quoted" member property name to the unique name of the hierarchy.

• PropertyOrder
  Type: System.Object

  Optional Object. Sets the PropertyOrder property value for a CubeField object. The actual position in the collection will be immediately before the PivotTable field that currently has the same PropertyOrder value that is given in the argument. If no field has the given property order value, the range of acceptable values is from 1 to the number of member properties already showing for the hierarchy plus one. This argument is one-based. If omitted, the property goes to the end of the list.

Remarks

The property field specified will not be viewable if the PivotTable view has no fields.

To delete member properties, use the Delete method to delete the PivotField object from the PivotFields collection.

See Also

Reference

CubeField Interface

CubeField Members

Microsoft.Office.Interop.Excel Namespace