Definition Type: ComplexType
Name: PivotViewType
Namespace: urn:schemas-microsoft-com:office:excel
Containing Schema: excel.xsd
Abstract
Documentation:
This element or attribute is not created or processed by Excel. It is designed to be used by external applications and components.
Collapse XSD Schema Diagram:
Drilldown into Label in schema excel_xsd Drilldown into CellsExpandedSeqNum in schema excel_xsd Drilldown into CellsNotExpanded in schema excel_xsd Drilldown into CellsExpanded in schema excel_xsd Drilldown into DetailSortOrder in schema excel_xsd Drilldown into FieldLabelFormat in schema excel_xsd Drilldown into MemberFormat in schema excel_xsd Drilldown into TotalFormat in schema excel_xsd Drilldown into DetailWidth in schema excel_xsd Drilldown into DetailRowHeight in schema excel_xsd Drilldown into NoDetailAutoFit in schema excel_xsd Drilldown into DetailMaxWidth in schema excel_xsd Drilldown into DetailMaxHeight in schema excel_xsd Drilldown into TotalAllMembers in schema excel_xsd Drilldown into IsNotFiltered in schema excel_xsdXSD Diagram of PivotViewType in schema excel_xsd (Microsoft Office 2003 Reference Schemas)
Collapse XSD Schema Code:
<xsd:complexType name="PivotViewType">
    <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:sequence>
        <xsd:element name="IsNotFiltered" 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="TotalAllMembers" 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="DetailMaxHeight" type="xsd:int" default="250" 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="DetailMaxWidth" type="xsd:int" default="1024" 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="NoDetailAutoFit" 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="DetailRowHeight" type="xsd:int" default="10" 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="DetailWidth" type="xsd:int" 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="TotalFormat" 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: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="MemberFormat" 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: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="FieldLabelFormat" 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: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="DetailSortOrder" type="xsd:string" minOccurs="0" maxOccurs="unbounded">
            <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:choice>
            <xsd:element name="CellsExpanded" 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="CellsNotExpanded" 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:choice>
        <xsd:element name="CellsExpandedSeqNum" type="xsd:int" 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="Label" minOccurs="0" maxOccurs="unbounded">
            <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: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:sequence>
</xsd:complexType>
Collapse Child Elements:
Name Type Min Occurs Max Occurs
IsNotFiltered x:IsNotFiltered 0 (1)
TotalAllMembers x:TotalAllMembers 0 (1)
DetailMaxHeight x:DetailMaxHeight 0 (1)
DetailMaxWidth x:DetailMaxWidth 0 (1)
NoDetailAutoFit x:NoDetailAutoFit 0 (1)
DetailRowHeight x:DetailRowHeight 0 (1)
DetailWidth x:DetailWidth 0 (1)
TotalFormat x:TotalFormat 0 (1)
MemberFormat x:MemberFormat 0 (1)
FieldLabelFormat x:FieldLabelFormat 0 (1)
DetailSortOrder x:DetailSortOrder 0 unbounded
CellsExpanded x:CellsExpanded 0 (1)
CellsNotExpanded x:CellsNotExpanded 0 (1)
CellsExpandedSeqNum x:CellsExpandedSeqNum 0 (1)
Label x:Label 0 unbounded
Collapse Derivation Tree:
Collapse References:
x:PivotView