PivotLocation.RowRange Property

Gets the cell range that contains the row area of the PivotTable report.

Namespace: DevExpress.Spreadsheet

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

Declaration

C#

Range RowRange { get; }

VB.NET

ReadOnly Property RowRange As Range

Property Value

Type	Description
Range	A Range object.

Remarks

The row area is highlighted in the following image.

To get a cell range that contains the entire pivot table including the page area, use the PivotLocation.WholeRange property. To obtain the cell range occupied by the pivot table disregarding the page area, use the PivotLocation.Range property. The PivotLocation.DataRange property returns the cell range that contains the PivotTable’s summary values. The PivotLocation.ColumnRange and PivotLocation.PageRange properties return cell ranges containing the PivotTable’s column area and page area, respectively.