ssml:location
PivotTable Location
Element information
Namespace: http://schemas.openxmlformats.org/spreadsheetml/2006/main
Schema document: sml-pivotTable.xsd
Type: ssml:CT_Location
Properties: Local, Qualified
Content
- Empty content
Attributes
| Name | Occ | Type | Description | Notes |
|---|---|---|---|---|
| ref | [1..1] | ssml:ST_Ref | Reference | |
| firstHeaderRow | [1..1] | xsd:unsignedInt | First Header Row | |
| firstDataRow | [1..1] | xsd:unsignedInt | PivotTable Data First Row | |
| firstDataCol | [1..1] | xsd:unsignedInt | First Data Column | |
| rowPageCount | [0..1] | xsd:unsignedInt | Rows Per Page Count | Default value is "0". |
| colPageCount | [0..1] | xsd:unsignedInt | Columns Per Page | Default value is "0". |
Used in
- Type ssml:CT_pivotTableDefinition (Element ssml:pivotTableDefinition)
Sample instance
<ssml:location ref="string" firstHeaderRow="1" firstDataRow="1" firstDataCol="1"/>