PTLineItemType complexType

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

Type Information

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

Elements and Attributes

Child Elements

Element Description
ItemType Specifies the type of data that is to appear in this row or column in the PivotTable view.
DataField Specifies which data field (of the PivotField items) this PTLineItem represents.
BlockTotal Contains a Boolean indicating if this PTLineItem is for a block total (a special type of subtotal displayed at the bottom of the PivotTable view).
CountOfSameItems Indicates how many repetitions of the outside header are required where columns or rows have multiple headers.
Item Contains the index for PivotItems.

Attributes

None.

Definition

      
<xsd:complexType name="PTLineItemType" >
  <xsd:sequence>
    <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>
    <xsd:element name="DataField" type="xsd:integer" default="1" minOccurs="0">
    </xsd:element>
    <xsd:element name="BlockTotal" minOccurs="0">
    </xsd:element>
    <xsd:element name="CountOfSameItems" type="xsd:int" default="0" minOccurs="0">
    </xsd:element>
    <xsd:element name="Item" type="xsd:string" minOccurs="0" maxOccurs="unbounded">
    </xsd:element>
  </xsd:sequence>
</xsd:complexType>


    
©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