Documentation for Microsoft Office 2003 Reference Schemas
Definition Type: ComplexType
Name: PTLineItemType
Namespace: urn:schemas-microsoft-com:office:excel
Containing Schema: excel.xsd
Abstract
Documentation:
Describes the layout of one row or column line in the PivotTable view.
Collapse XSD Schema Diagram:
Drilldown into Item in schema excel_xsd Drilldown into CountOfSameItems in schema excel_xsd Drilldown into BlockTotal in schema excel_xsd Drilldown into DataField in schema excel_xsd Drilldown into ItemType in schema excel_xsdXSD Diagram of PTLineItemType in schema excel_xsd (Microsoft Office 2003 Reference Schemas)
Collapse XSD Schema Code: 
<xsd:complexType name="PTLineItemType">
    <xsd:annotation>
        <xsd:documentation>Describes the layout of one row or column line in the PivotTable view.</xsd:documentation>
    </xsd:annotation>
    <xsd:sequence>
        <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>
        <xsd:element name="DataField" type="xsd:integer" default="1" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies which data field (of the PivotField items) this PTLineItem represents.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="BlockTotal" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>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).</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="CountOfSameItems" type="xsd:int" default="0" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Indicates how many repetitions of the outside header are required where columns or rows have multiple headers.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="Item" type="xsd:string" minOccurs="0" maxOccurs="unbounded">
            <xsd:annotation>
                <xsd:documentation>Contains the index for PivotItems.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
    </xsd:sequence>
</xsd:complexType>
Collapse Child Elements:
Name Type Min Occurs Max Occurs
ItemType x:ItemType 0 (1)
DataField x:DataField 0 (1)
BlockTotal x:BlockTotal 0 (1)
CountOfSameItems x:CountOfSameItems 0 (1)
Item x:Item 0 unbounded
Collapse Derivation Tree:
Collapse References:
x:PTLineItem
Documentation for Microsoft Office 2003 Reference Schemas

Generated using Liquid Studio - Developer Bundle 21.0.0.0