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.v24.2.Core.dll

NuGet Package: DevExpress.Spreadsheet.Core

Declaration

C#

PivotLocation Location { get; }

VB.NET

ReadOnly Property Location As PivotLocation

Property Value

Type	Description
PivotLocation	A PivotLocation object containing location information for a PivotTable report.

Remarks

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