Location Information

Location provides details on where the PivotTable is located in the sheet.

<location ref="B6:G13" firstHeaderRow="1" firstDataRow="4"
  firstDataCol="1" rowPageCount="3" colPageCount="1"/>

In the context of <location>:

  • @ref the location of the PivotTable area, not including the report filter area.

  • @firstHeaderRow the first row of the PivotTable header, relative to the top left cell in @ref value.

  • @firstDataRow the first row of the PivotTable values area, relative to the top left cell in @ref value.

  • @firstDataCol the first column of the PivotTable values area, relative to the top left cell in @ref value.

  • @rowPageCount indicates how many rows the report filter area will occupy, as fields are added to it, before taking up another column (there can be multiple rows and columns of fields in the report filter area). By default there is a single column of report filter fields and the fields occupy as many rows as there are fields..

  • @colPageCount indicates how many columns the report filter region will occupy, as fields are added to it, before taking up another row (there can be multiple rows and columns of fields in the report filter region). By default, there is a single column of report filter fields and the fields occupy as many rows as there are fields.