Skip to main content
Row

DevExpress v24.2 Update — Your Feedback Matters

Our What's New in v24.2 webpage includes product-specific surveys. Your response to our survey questions will help us measure product satisfaction for features released in this major update and help us refine our plans for our next major release.

Take the survey Not interested

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.2.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