WorksheetClass.PivotTableWizard Method

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

Syntax

'Declaration
Public Overridable Function 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 _
) As PivotTable
'Usage
Dim instance As WorksheetClass
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
Dim returnValue As PivotTable

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

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

Return Value

Type: Microsoft.Office.Interop.Excel.PivotTable

Implements

_Worksheet.PivotTableWizard(Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object)

See Also

Reference

WorksheetClass Class

WorksheetClass Members

Microsoft.Office.Interop.Excel Namespace