complexType PivotAxisType

complexType {urn:schemas-microsoft-com:office:excel}PivotAxisType

Abstractfalse (This can be used in an instance)
Target Namespaceurn:schemas-microsoft-com:office:excel
Declared Namespacesxmlns:xsd=http://www.w3.org/2001/XMLSchema
xmlns:rs=urn:schemas-microsoft-com:rowset
xmlns:s=uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882
xmlns=urn:schemas-microsoft-com:office:excel


Source

<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>


Documentation

Specifies additional information about a PivotTable view axis or location.


complexType PivotAxisType


Stylus Studio XML Schema Library Home
Site Map | Privacy Policy | Terms of Use | Trademarks
Stylus Scoop XML Newsletter:
W3C Member
Stylus Studio®, a product from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2006 All Rights Reserved.