Share via

IPivotTable.PivotTableWizard Method

  • Article

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

Syntax

'Declaration
Sub PivotTableWizard ( _
    SourceType As Object, _
    SourceData As Object, _
    TableDestination As Object, _
    TableName As Object, _
    RowGrand As Object, _
    ColumnGrand As Object, _
    SaveData As Object, _
    HasAutoFormat As Object, _
    AutoPage As Object, _
    Reserved As Object, _
    BackgroundQuery As Object, _
    OptimizeCache As Object, _
    PageFieldOrder As Object, _
    PageFieldWrapCount As Object, _
    ReadData As Object, _
    Connection As Object _
)
'Usage
Dim instance As IPivotTable
Dim SourceType As Object
Dim SourceData As Object
Dim TableDestination As Object
Dim TableName As Object
Dim RowGrand As Object
Dim ColumnGrand As Object
Dim SaveData As Object
Dim HasAutoFormat As Object
Dim AutoPage As Object
Dim Reserved As Object
Dim BackgroundQuery As Object
Dim OptimizeCache As Object
Dim PageFieldOrder As Object
Dim PageFieldWrapCount As Object
Dim ReadData As Object
Dim Connection As Object

instance.PivotTableWizard(SourceType, _
    SourceData, TableDestination, TableName, _
    RowGrand, ColumnGrand, SaveData, _
    HasAutoFormat, AutoPage, Reserved, _
    BackgroundQuery, OptimizeCache, _
    PageFieldOrder, PageFieldWrapCount, _
    ReadData, Connection)

void PivotTableWizard(
    Object SourceType,
    Object SourceData,
    Object TableDestination,
    Object TableName,
    Object RowGrand,
    Object ColumnGrand,
    Object SaveData,
    Object HasAutoFormat,
    Object AutoPage,
    Object Reserved,
    Object BackgroundQuery,
    Object OptimizeCache,
    Object PageFieldOrder,
    Object PageFieldWrapCount,
    Object ReadData,
    Object Connection
)

Parameters

See Also

Reference

IPivotTable Interface

IPivotTable Members

Microsoft.Office.Interop.Excel Namespace