PivotPageArea

type PivotPageArea = {
  firstRow: number;
  labelCol: number;
  rowCount: number;
  valueCol: number;
};

Geometry of a pivot’s page-field (report filter) area, which sits above the pivot’s output area, outside ref (Excel’s location/@ref excludes it). Offsets are relative to the top-left of ref; firstRow is negative. The fields stack one per row in a single label/value column pair. Absent (or null) when the pivot has no page fields.

Properties

Property	Type	Description
firstRow	number	Ref-relative row offset of the first page-field row (negative; -(rowCount + 1)).
labelCol	number	Ref-relative column offset of the field-caption (label) cells.
rowCount	number	Number of page-field rows (one per page field).
valueCol	number	Ref-relative column offset of the selected-item (value) cells.