Aggregate element

Indicates the kind of aggregation to be done in the totals row.

Usage

      
<Aggregate />

    

Element Information

Element type Anonymous
Namespace http://schemas.microsoft.com/office/excel/2003/xml
Schema name XML Spreadsheet 2003

Elements and Attributes

Parent Elements

Element Description
Field Specifies the cell or cells in the spreadsheet that are being mapped.

Child Elements

None.

Attributes

None.

Definition

      
<xsd:element name="Aggregate" minOccurs="0" default="None" >
  <xsd:simpleType>
    <xsd:restriction base="xsd:string">
      <xsd:enumeration value="None" />
      <xsd:enumeration value="Sum" />
      <xsd:enumeration value="Count" />
      <xsd:enumeration value="CountNums" />
      <xsd:enumeration value="Var" />
      <xsd:enumeration value="Average" />
      <xsd:enumeration value="stdDev" />
      <xsd:enumeration value="Max" />
      <xsd:enumeration value="Min" />
    </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