[Table of Contents] [docx version]

SpreadsheetML Reference Material - Table of Contents

ST_Axis (PivotTable Axis)

This simple type defines the axes for a PivotTable selection.

This simple type's contents are a restriction of the XML Schema string datatype.

The following are possible enumeration values for this type:

Enumeration Value

Description

axisCol (Column Axis)

Column axis

axisPage (Include Count Filter)

Page axis

axisRow (Row Axis)

Row axis

axisValues (Values Axis)

Values axis

 

Referenced By

pivotArea@axis3.3.1.66); pivotField@axis3.10.1.69); pivotSelection@axis3.3.1.67)

The following XML Schema fragment defines the contents of this simple type:

<simpleType name="ST_Axis">

   <restriction base="xsd:string">

   <enumeration value="axisRow"/>

   <enumeration value="axisCol"/>

   <enumeration value="axisPage"/>

   <enumeration value="axisValues"/>

   </restriction>

</simpleType>