IPivotTable.GetPivotData Method

Article
01/20/2015

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 IPivotTable
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
)