.NET Framework 4.5.2+
.NET Framework 4.5.2+
.NET Standard 2.0+
Row

PivotLocation.ColumnRange Property

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

Namespace: DevExpress.Spreadsheet

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

Declaration

CellRange ColumnRange { get; }

Property Value

Type Description
CellRange

A CellRange object.

Remarks

The column area is highlighted in the following image.

PivotLocation_ColumnLabelsRange

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

See Also