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