Skip to main content
Row

DevExpress v24.2 Update — Your Feedback Matters

Our What's New in v24.2 webpage includes product-specific surveys. Your response to our survey questions will help us measure product satisfaction for features released in this major update and help us refine our plans for our next major release.

Take the survey Not interested

PivotLocation.DataRange Property

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

Namespace: DevExpress.Spreadsheet

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

NuGet Package: DevExpress.Spreadsheet.Core

#Declaration

CellRange DataRange { get; }

#Property Value

Type Description
CellRange

A CellRange object.

#Remarks

The data area is highlighted in the following image.

PivotLocation_DataRange

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.RowRange, PivotLocation.ColumnRange and PivotLocation.PageRange properties return cell ranges containing the PivotTable’s row area, column area and page area, respectively.

See Also