[]
DEMOS DOCS API BLOG SUPPORT PRICING DOWNLOAD
(Showing Draft Content)

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 Command
Parameters
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