ItemType element

Specifies the type of data that is to appear in this row or column in the PivotTable view.

Usage

      
<ItemType />

    

Element Information

Element type Anonymous
Namespace urn:schemas-microsoft-com:office:excel
Schema name XML Spreadsheet 2000

Elements and Attributes

Parent Elements

Element Description
PTLineItem Describes the layout of one row or column line in the PivotTable view.

Child Elements

None.

Attributes

None.

Definition

      
<xsd:element name="ItemType" default="Data" minOccurs="0" >
  <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>


    
©2003-2004 Microsoft Corporation. All rights reserved. Permission to copy, display and distribute this document is available at: http://msdn.microsoft.com/library/en-us/odcXMLRef/html/odcXMLRefLegalNotice.asp