Documentation for Microsoft Office 2003 Reference Schemas
Definition Type: ComplexType
Name: PivotAxisType
Namespace: urn:schemas-microsoft-com:office:excel
Containing Schema: excel.xsd
Abstract
Documentation:
Specifies additional information about a PivotTable view axis or location.
Collapse XSD Schema Diagram:
Drilldown into Orientation in schema excel_xsd Drilldown into Label in schema excel_xsd Drilldown into DisplayEmptyMembers in schema excel_xsdXSD Diagram of PivotAxisType in schema excel_xsd (Microsoft Office 2003 Reference Schemas)
Collapse XSD Schema Code: 
<xsd:complexType name="PivotAxisType">
    <xsd:annotation>
        <xsd:documentation>Specifies additional information about a PivotTable view axis or location.</xsd:documentation>
    </xsd:annotation>
    <xsd:sequence>
        <xsd:element name="DisplayEmptyMembers" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies a Boolean value indicating whether empty items should be displayed in the PivotTable view.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="Label" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>This element or attribute is not created or processed by Excel. It is designed to be used by external applications and components.</xsd:documentation>
            </xsd:annotation>
            <xsd:complexType>
                <xsd:sequence>
                    <xsd:element name="Caption" type="xsd:string" minOccurs="0">
                        <xsd:annotation>
                            <xsd:documentation>This element or attribute is not created or processed by Excel. It is designed to be used by external applications and components.</xsd:documentation>
                        </xsd:annotation>
                    </xsd:element>
                    <xsd:element name="NotVisible" minOccurs="0">
                        <xsd:annotation>
                            <xsd:documentation>This element or attribute is not created or processed by Excel. It is designed to be used by external applications and components.</xsd:documentation>
                        </xsd:annotation>
                    </xsd:element>
                </xsd:sequence>
                <xsd:attribute name="Style" type="xsd:string" use="required">
                    <xsd:annotation>
                        <xsd:documentation>This element or attribute is not created or processed by Excel. It is designed to be used by external applications and components.</xsd:documentation>
                    </xsd:annotation>
                </xsd:attribute>
            </xsd:complexType>
        </xsd:element>
        <xsd:element name="Orientation">
            <xsd:annotation>
                <xsd:documentation>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.</xsd:documentation>
            </xsd:annotation>
            <xsd:simpleType>
                <xsd:annotation>
                    <xsd:documentation>Contains an enumerated value indicating where a field is located in a PivotTable area.</xsd:documentation>
                </xsd:annotation>
                <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>
Collapse Child Elements:
Name Type Min Occurs Max Occurs
DisplayEmptyMembers x:DisplayEmptyMembers 0 (1)
Label x:Label 0 (1)
Orientation x:Orientation (1) (1)
Collapse Derivation Tree:
Collapse References:
x:PivotAxis
Documentation for Microsoft Office 2003 Reference Schemas

Generated using Liquid Studio - Developer Bundle 21.0.0.0