Back to Devexpress

PivotLocation.DataRange Property

officefileapi-devexpress-dot-spreadsheet-dot-pivotlocation-095a1ddc.md

latest2.2 KB
Original Source

PivotLocation.DataRange Property

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

Namespace : DevExpress.Spreadsheet

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

NuGet Package : DevExpress.Spreadsheet.Core

Declaration

csharp
CellRange DataRange { get; }
vb
ReadOnly Property DataRange As CellRange

Property Value

TypeDescription
CellRange

A CellRange object.

|

Remarks

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

See Also

Pivot Table Structure

PivotLocation Interface

PivotLocation Members

DevExpress.Spreadsheet Namespace