FieldType complexType

Specifies which cells in the spreadsheet are to be mapped to the data pointed to by the XPath element.

Type Information

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

Elements and Attributes

Child Elements

Element Description
Range Contains a relative address that specifies which column is to be used for each of the elements mapped from the XML document.
XPath Contains a relative path from the parent element to the child element that is to be mapped to the column specified in the Range element.
XSDType "Contains the data type of the element or attribute being mapped, using the data types from the W3C Schema specification."
Aggregate Indicates the kind of aggregation to be done in the totals row.
ss:Cell See external namespace.
x:DataValidation See external namespace.
x:AutoFilterColumn See external namespace.

Attributes

Attribute Type Required Description Possible Values
ID xsd:string optional Specifies the column heading value. See external namespace.

Definition

      
<xsd:complexType name="FieldType" >
  <xsd:sequence>
    <xsd:element name="Range" type="xsd:string" minOccurs="0">
    </xsd:element>
    <xsd:element name="XPath" type="xsd:string" minOccurs="0">
    </xsd:element>
    <xsd:element name="XSDType" type="xsd:string" minOccurs="0">
    </xsd:element>
    <xsd:element ref="ss:Cell" minOccurs="0" />
    <xsd:element ref="x:DataValidation" minOccurs="0" />
    <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>
    <xsd:element ref="x:AutoFilterColumn" minOccurs="0" />
  </xsd:sequence>
  <xsd:attribute name="ID" type="xsd:string">
  </xsd:attribute>
</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