Describes the layout of one row or column line in the PivotTable view.
Namespace | urn:schemas-microsoft-com:office:excel |
Schema name | XML Spreadsheet 2000 |
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. |
None.
<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>