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.