Definition Type: Element
Name: ItemType
Namespace: urn:schemas-microsoft-com:office:excel
Type: string:http://www.w3.org/2001/XMLSchema
Containing Schema: excel.xsd
MinOccurs 0
MaxOccurs (1)
Abstract
ContentType Restriction
Default Data
Documentation:
Specifies the type of data that is to appear in this row or column in the PivotTable view.
Collapse XSD Schema Diagram:
XSD Diagram of ItemType in schema excel_xsd (Microsoft Office 2003 Reference Schemas)
Collapse XSD Schema Code:
<xsd:element name="ItemType" default="Data" minOccurs="0">
    <xsd:annotation>
        <xsd:documentation>Specifies the type of data that is to appear in this row or column in the PivotTable view.</xsd:documentation>
    </xsd:annotation>
    <xsd:simpleType>
        <xsd:restriction base="xsd:string">
            <xsd:enumeration value="Avg" />
            <xsd:enumeration value="Count" />
            <xsd:enumeration value="CountNums" />
            <xsd:enumeration value="Max" />
            <xsd:enumeration value="Min" />
            <xsd:enumeration value="Product" />
            <xsd:enumeration value="StdDev" />
            <xsd:enumeration value="StdDevP" />
            <xsd:enumeration value="Sum" />
            <xsd:enumeration value="Var" />
            <xsd:enumeration value="VarP" />
            <xsd:enumeration value="Blank" />
            <xsd:enumeration value="Data" />
            <xsd:enumeration value="Default" />
            <xsd:enumeration value="Grand" />
        </xsd:restriction>
    </xsd:simpleType>
</xsd:element>
Collapse Facets:
Facet Value
Enumeration Avg
Enumeration Count
Enumeration CountNums
Enumeration Max
Enumeration Min
Enumeration Product
Enumeration StdDev
Enumeration StdDevP
Enumeration Sum
Enumeration Var
Enumeration VarP
Enumeration Blank
Enumeration Data
Enumeration Default
Enumeration Grand