Specifies additional information about a PivotTable view axis or location.
Namespace | urn:schemas-microsoft-com:office:excel |
Schema name | XML Spreadsheet 2000 |
Element | Description |
---|---|
DisplayEmptyMembers | Specifies a Boolean value indicating whether empty items should be displayed in the PivotTable view. |
Label | This element or attribute is not created or processed by Excel. It is designed to be used by external applications and components. |
Caption | This element or attribute is not created or processed by Excel. It is designed to be used by external applications and components. |
NotVisible | This element or attribute is not created or processed by Excel. It is designed to be used by external applications and components. |
Orientation | Specifies whether the PivotTable properties in a PTLineItems element apply to a row or column, or specifies the orientation of a PivotTable field or a cube field axis. |
Attribute | Type | Required | Description | Possible Values |
---|---|---|---|---|
Style | xsd:string | required | This element or attribute is not created or processed by Excel. It is designed to be used by external applications and components. | See external namespace. |
<xsd:complexType name="PivotAxisType" >
<xsd:sequence>
<xsd:element name="DisplayEmptyMembers" minOccurs="0">
</xsd:element>
<xsd:element name="Label" minOccurs="0">
<xsd:complexType>
<xsd:sequence>
<xsd:element name="Caption" type="xsd:string" minOccurs="0">
</xsd:element>
<xsd:element name="NotVisible" minOccurs="0">
</xsd:element>
</xsd:sequence>
<xsd:attribute name="Style" type="xsd:string" use="required">
</xsd:attribute>
</xsd:complexType>
</xsd:element>
<xsd:element name="Orientation">
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:enumeration value="Hidden" />
<xsd:enumeration value="Row" />
<xsd:enumeration value="Column" />
<xsd:enumeration value="Filter" />
<xsd:enumeration value="Data" />
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
</xsd:sequence>
</xsd:complexType>