PivotTableCollection.Add(CellRange, CellRange, String) Method

Creates a pivot table with a custom name based on data in the specified cell range and returns the newly created PivotTable object.

Namespace : DevExpress.Spreadsheet

Assembly : DevExpress.Spreadsheet.v25.2.Core.dll

NuGet Package : DevExpress.Spreadsheet.Core

Declaration

csharp

PivotTable Add(
    CellRange sourceRange,
    CellRange location,
    string name
)

Function Add(
    sourceRange As CellRange,
    location As CellRange,
    name As String
) As PivotTable

Name	Type	Description
sourceRange	CellRange

A CellRange object that specifies a cell range containing the source data for the pivot table.

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

Type	Description
PivotTable

A PivotTable object that specifies the newly created pivot table.