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