PivotTable.GetPivotData Method

  • Article

Returns a Range object with information about a data item in a PivotTable report.

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

Syntax

'Declaration
Function GetPivotData ( _
    DataField As Object, _
    Field1 As Object, _
    Item1 As Object, _
    Field2 As Object, _
    Item2 As Object, _
    Field3 As Object, _
    Item3 As Object, _
    Field4 As Object, _
    Item4 As Object, _
    Field5 As Object, _
    Item5 As Object, _
    Field6 As Object, _
    Item6 As Object, _
    Field7 As Object, _
    Item7 As Object, _
    Field8 As Object, _
    Item8 As Object, _
    Field9 As Object, _
    Item9 As Object, _
    Field10 As Object, _
    Item10 As Object, _
    Field11 As Object, _
    Item11 As Object, _
    Field12 As Object, _
    Item12 As Object, _
    Field13 As Object, _
    Item13 As Object, _
    Field14 As Object, _
    Item14 As Object _
) As Range
'Usage
Dim instance As PivotTable
Dim DataField As Object
Dim Field1 As Object
Dim Item1 As Object
Dim Field2 As Object
Dim Item2 As Object
Dim Field3 As Object
Dim Item3 As Object
Dim Field4 As Object
Dim Item4 As Object
Dim Field5 As Object
Dim Item5 As Object
Dim Field6 As Object
Dim Item6 As Object
Dim Field7 As Object
Dim Item7 As Object
Dim Field8 As Object
Dim Item8 As Object
Dim Field9 As Object
Dim Item9 As Object
Dim Field10 As Object
Dim Item10 As Object
Dim Field11 As Object
Dim Item11 As Object
Dim Field12 As Object
Dim Item12 As Object
Dim Field13 As Object
Dim Item13 As Object
Dim Field14 As Object
Dim Item14 As Object
Dim returnValue As Range

returnValue = instance.GetPivotData(DataField, _
    Field1, Item1, Field2, Item2, Field3, _
    Item3, Field4, Item4, Field5, Item5, _
    Field6, Item6, Field7, Item7, Field8, _
    Item8, Field9, Item9, Field10, Item10, _
    Field11, Item11, Field12, Item12, _
    Field13, Item13, Field14, Item14)

Range GetPivotData(
    Object DataField,
    Object Field1,
    Object Item1,
    Object Field2,
    Object Item2,
    Object Field3,
    Object Item3,
    Object Field4,
    Object Item4,
    Object Field5,
    Object Item5,
    Object Field6,
    Object Item6,
    Object Field7,
    Object Item7,
    Object Field8,
    Object Item8,
    Object Field9,
    Object Item9,
    Object Field10,
    Object Item10,
    Object Field11,
    Object Item11,
    Object Field12,
    Object Item12,
    Object Field13,
    Object Item13,
    Object Field14,
    Object Item14
)

Parameters

  • DataField
    Type: System.Object

    Optional Object. The name of the field containing the data for the PivotTable.

  • Field1
    Type: System.Object

    Optional Object. The name of a column or row field in the PivotTable report.

  • Item1
    Type: System.Object

    Optional Object. The name of an item in Field1.

  • Field2
    Type: System.Object

    Optional Object. The name of a column or row field in the PivotTable report.

  • Item2
    Type: System.Object

    Optional Object. The name of an item in Field2.

  • Field3
    Type: System.Object

    Optional Object. The name of a column or row field in the PivotTable report.

  • Item3
    Type: System.Object

    Optional Object. The name of an item in Field3.

  • Field4
    Type: System.Object

    Optional Object. The name of a column or row field in the PivotTable report.

  • Item4
    Type: System.Object

    Optional Object. The name of an item in Field4.

  • Field5
    Type: System.Object

    Optional Object. The name of a column or row field in the PivotTable report.

  • Item5
    Type: System.Object

    Optional Object. The name of an item in Field5.

  • Field6
    Type: System.Object

    Optional Object. The name of a column or row field in the PivotTable report.

  • Item6
    Type: System.Object

    Optional Object. The name of an item in Field6.

  • Field7
    Type: System.Object

    Optional Object. The name of a column or row field in the PivotTable report.

  • Item7
    Type: System.Object

    Optional Object. The name of an item in Field7.

  • Field8
    Type: System.Object

    Optional Object. The name of a column or row field in the PivotTable report.

  • Item8
    Type: System.Object

    Optional Object. The name of an item in Field8.

  • Field9
    Type: System.Object

    Optional Object. The name of a column or row field in the PivotTable report.

  • Item9
    Type: System.Object

    Optional Object. The name of an item in Field9.

  • Field10
    Type: System.Object

    Optional Object. The name of a column or row field in the PivotTable report.

  • Item10
    Type: System.Object

    Optional Object. The name of an item in Field10.

  • Field11
    Type: System.Object

    Optional Object. The name of a column or row field in the PivotTable report.

  • Item11
    Type: System.Object

    Optional Object. The name of an item in Field11.

  • Field12
    Type: System.Object

    Optional Object. The name of a column or row field in the PivotTable report.

  • Item12
    Type: System.Object

    Optional Object. The name of an item in Field12.

  • Field13
    Type: System.Object

    Optional Object. The name of a column or row field in the PivotTable report.

  • Item13
    Type: System.Object

    Optional Object. The name of an item in Field13.

  • Field14
    Type: System.Object

    Optional Object. The name of a column or row field in the PivotTable report.

  • Item14
    Type: System.Object

    Optional Object. The name of an item in Field14.

Return Value

Type: Microsoft.Office.Interop.Excel.Range

See Also

Reference

PivotTable Interface

PivotTable Members

Microsoft.Office.Interop.Excel Namespace