Definition Type: Element
Name: PTPivotData
Namespace: urn:schemas-microsoft-com:office:excel
Containing Schema: excel.xsd
Abstract
Documentation:
Contains a description of the state of PivotTable data, including whether members are expanded and the position of a view.
Collapse XSD Schema Diagram:
Drilldown into Column in schema excel_xsd Drilldown into LeafColumnMember in schema excel_xsd Drilldown into LeafRowMember in schema excel_xsd Drilldown into InvertedColumnMember in schema excel_xsd Drilldown into InvertedRowMember in schema excel_xsd Drilldown into Left in schema excel_xsd Drilldown into Top in schema excel_xsdXSD Diagram of PTPivotData in schema excel_xsd (Microsoft Office 2003 Reference Schemas)
Collapse XSD Schema Code:
<xsd:element name="PTPivotData">
    <xsd:annotation>
        <xsd:documentation>Contains a description of the state of PivotTable data, including whether members are expanded and the position of a view.</xsd:documentation>
    </xsd:annotation>
    <xsd:complexType>
        <xsd:sequence>
            <xsd:element name="Top" type="xsd:int" minOccurs="0">
                <xsd:annotation>
                    <xsd:documentation>Specifies the vertical position of an object within a chart area or Chart component, or for a PivotList component, the row index visible at the top of a cell or view.</xsd:documentation>
                </xsd:annotation>
            </xsd:element>
            <xsd:element name="Left" type="xsd:int" minOccurs="0">
                <xsd:annotation>
                    <xsd:documentation>Specifies the horizontal position of an object within the chart area or Chart component, or for a PivotList component, the column index of the first visible detail column, or the index of the member visible at the left of a view.</xsd:documentation>
                </xsd:annotation>
            </xsd:element>
            <xsd:element name="InvertedRowMember" type="xsd:string" minOccurs="0" maxOccurs="unbounded">
                <xsd:annotation>
                    <xsd:documentation>Specifies whether a row member has a different expanded state than its default state.</xsd:documentation>
                </xsd:annotation>
            </xsd:element>
            <xsd:element name="InvertedColumnMember" type="xsd:string" minOccurs="0" maxOccurs="unbounded">
                <xsd:annotation>
                    <xsd:documentation>Specifies whether a column member has a different expanded state than its default state.</xsd:documentation>
                </xsd:annotation>
            </xsd:element>
            <xsd:element name="LeafRowMember" type="LeafRowMemberType" minOccurs="0" maxOccurs="unbounded">
                <xsd:annotation>
                    <xsd:documentation>Contains the properties of a leaf row member that has been expanded or collapsed since the view's state changed.</xsd:documentation>
                </xsd:annotation>
            </xsd:element>
            <xsd:element name="LeafColumnMember" type="LeafColumnMemberType" minOccurs="0" maxOccurs="unbounded">
                <xsd:annotation>
                    <xsd:documentation>Contains the properties of a leaf column member that has been expanded or collapsed since the view's state changed.</xsd:documentation>
                </xsd:annotation>
            </xsd:element>
            <xsd:element name="Column" type="ColumnType" minOccurs="0" maxOccurs="unbounded">
                <xsd:annotation>
                    <xsd:documentation>Specifies the index of a row page break in a worksheet, or for a PivotList component, represents a column of cells.</xsd:documentation>
                </xsd:annotation>
            </xsd:element>
        </xsd:sequence>
    </xsd:complexType>
</xsd:element>
Collapse Child Elements:
Name Type Min Occurs Max Occurs
Top x:Top 0 (1)
Left x:Left 0 (1)
InvertedRowMember x:InvertedRowMember 0 unbounded
InvertedColumnMember x:InvertedColumnMember 0 unbounded
LeafRowMember x:LeafRowMember 0 unbounded
LeafColumnMember x:LeafColumnMember 0 unbounded
Column x:Column 0 unbounded