- Spread for WPF API Overview
- GrapeCity.CalcEngine Assembly
-
GrapeCity.Spreadsheet Assembly
- GrapeCity.CalcEngine
- GrapeCity.Core
- GrapeCity.Drawing
- GrapeCity.Spreadsheet
- GrapeCity.Spreadsheet.API.PivotTables
- GrapeCity.Spreadsheet.Charts
- GrapeCity.Spreadsheet.Commands
-
GrapeCity.Spreadsheet.Commands.PivotTables
-
Classes
-
PivotTableCommand
-
Methods
- AddField
- AddPivotStyle
- ApplyPivotStyle
- AutoGroup
- ChangeField
- ClearFilters
- CreateFieldSettings
- CreatePivotTable
- DeleteField
- DeletePivotTable
- DrillToPivotField
- ExpandCollapsePivotField
- Filter
- Group
- ModifyPivotStyle
- MoveField
- MovePivotField
- Options
- PageFilter
- RefreshCaches
- RefreshPivotTable
- ReplacePivotStyle
- SortField
- ToggleDetailFieldItem
- Ungroup
- UpdateDataFieldSettings
- UpdateFields
- UpdatePivotField
- UpdateShowValuesAsSettings
- Properties
-
Methods
- PivotTableOptionsCommand
-
PivotTableCommand
-
Classes
- GrapeCity.Spreadsheet.Data
- GrapeCity.Spreadsheet.Drawing
- GrapeCity.Spreadsheet.FormControls
- GrapeCity.Spreadsheet.IO
- GrapeCity.Spreadsheet.IO.OpenXml
- GrapeCity.Spreadsheet.Localization
- GrapeCity.Spreadsheet.PivotTables
- GrapeCity.Spreadsheet.Printing
- GrapeCity.Spreadsheet.UI
- GrapeCity.Wpf.SpreadSheet Assembly
- GrapeCity.Wpf.Spreadsheet.CellType Assembly
GrapeCity.Spreadsheet.Commands.PivotTables.PivotTableCommand.CreatePivotTable
CreatePivotTable Method
CreatePivotTable(IWorkbook, string, string)
Creates a PivotTable report from table.
Declaration
public static Command CreatePivotTable(IWorkbook workbook, string sourceReference, string destinationReference)Public Shared Function CreatePivotTable(workbook As IWorkbook, sourceReference As String, destinationReference As String) As CommandParameters
| Type | Name | Description |
|---|---|---|
| IWorkbook | workbook | The workbook which this command attached to. |
| string | sourceReference | The source range reference for the new PivotTable cache which used for creating PivotTable report. |
| string | destinationReference | The cell in the upper-left corner of the PivotTable report's destination range reference (the range on the worksheet where the resulting PivotTable report will be placed). |
Returns
| Type | Description |
|---|---|
| Command |