WorkbookClass.PivotTableWizard Method

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

Syntax

'Declaration
Public Overridable 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 WorkbookClass
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)

public virtual 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

• SourceType
  Type: System.Object

• SourceData
  Type: System.Object

• TableDestination
  Type: System.Object

• TableName
  Type: System.Object

• RowGrand
  Type: System.Object

• ColumnGrand
  Type: System.Object

• SaveData
  Type: System.Object

• HasAutoFormat
  Type: System.Object

• AutoPage
  Type: System.Object

• Reserved
  Type: System.Object

• BackgroundQuery
  Type: System.Object

• OptimizeCache
  Type: System.Object

• PageFieldOrder
  Type: System.Object

• PageFieldWrapCount
  Type: System.Object

• ReadData
  Type: System.Object

• Connection
  Type: System.Object

Implements

_Workbook.PivotTableWizard(Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object)

See Also

Reference

WorkbookClass Class

WorkbookClass Members

Microsoft.Office.Interop.Excel Namespace