element PTPivotData

element {urn:schemas-microsoft-com:office:excel}PTPivotData

Abstractfalse (This can be used in an instance)
Nillablefalse (Instance values cannot use xsi:nil)
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: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>


Documentation

Contains a description of the state of PivotTable data, including whether members are expanded and the position of a view.


element PTPivotData


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.