PivotTableCollection.Add(Range, Range, 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.v19.1.Core.dll

Declaration

C#

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

VB.NET

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

Parameters

Name	Type	Description
sourceRange	Range	A Range object that specifies a cell range containing the source data for the pivot table.
location	Range	A Range 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.