Skip to main content
Row

PivotTableCollection.Add(PivotCache, CellRange, String) Method

Creates a new pivot table with a custom name using the specified data cache and returns the newly created PivotTable object.

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v24.1.Core.dll

NuGet Package: DevExpress.Spreadsheet.Core

Declaration

PivotTable Add(
    PivotCache cache,
    CellRange location,
    string name
)

Parameters

Name Type Description
cache PivotCache

A PivotCache object that specifies the pivot cache on which the pivot table is based.

location CellRange

A CellRange object that specifies a cell or cell range in the upper-left corner of the PivotTable report’s destination range.

name String

A String value that specifies the pivot table name. This value is assigned to the PivotTable.Name property.

Returns

Type Description
PivotTable

A PivotTable object that specifies the newly created pivot table.

See Also