Share via

PivotField.AddPageItem Method

  • Article

Adds an additional item to a multiple item page field.

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

Syntax

'Declaration
Sub AddPageItem ( _
    Item As String, _
    ClearList As Object _
)
'Usage
Dim instance As PivotField
Dim Item As String
Dim ClearList As Object

instance.AddPageItem(Item, ClearList)

void AddPageItem(
    string Item,
    Object ClearList
)

Parameters

  • Item
    Type: System.String

    Required String. Source name of a PivotItem object, corresponding to the specific Online Analytical Processing (OLAP) member unique name.

  • ClearList
    Type: System.Object

    Optional Object. If False (default), adds a page item to the existing list. If True, deletes all current items and adds Item.

Remarks

To avoid run-time errors, the data source must be an OLAP source, the field chosen must currently be in the page position, and the EnableMultiplePageItems property must be set to True.

See Also

Reference

PivotField Interface

PivotField Members

Microsoft.Office.Interop.Excel Namespace