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

NuGet Package : DevExpress.Spreadsheet.Core

Declaration

• C#
• VB.NET

PivotLocation Location { get; }

ReadOnly Property Location As PivotLocation

Property Value

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

See Also

PivotTable Interface

PivotTable Members

DevExpress.Spreadsheet Namespace