.NET Framework 4.5.2+
.NET Framework 4.5.2+
.NET Standard 2.0+

PivotTable.Location Property

Provides access to an object that contains information about the location of a pivot table and its regions.

Namespace: DevExpress.Spreadsheet

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


PivotLocation Location { get; }

Property Value

Type Description

A PivotLocation object containing location information for a PivotTable report.


Use the Location property to access an object exposing the PivotLocation interface. Utilize properties of the returned object to obtain the cell range that contains the entire PivotTable report (PivotLocation.WholeRange or PivotLocation.Range) or its specific areas: the row area (PivotLocation.RowRange), column area (PivotLocation.ColumnRange), page area (PivotLocation.PageRange), or data area (PivotLocation.DataRange).

See Also