1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
|
<html dir="ltr"><head>
<META http-equiv="Content-Type" content="text/html; charset=UTF-8">
<META HTTP-EQUIV="assetid" CONTENT="HV01105195"><META NAME="lcid" CONTENT="1033"><title>FieldType complexType</title><link rel="stylesheet" type="text/css" href="office10.css"><script type="text/javascript" language="Javascript" src="ExpCollapse.js"></script><script type="text/javascript" language="JavaScript" src="inline.js"></script></head><body><h1>FieldType complexType</h1><p>Specifies which cells in the spreadsheet are to be mapped to the data pointed to by the XPath element.</p><h2>Type Information</h2><table>
<tr>
<td>
<b class="bterm">Namespace</b>
</td>
<td>http://schemas.microsoft.com/office/excel/2003/xml</td>
</tr>
<tr>
<td>
<b class="bterm">Schema name</b>
</td>
<td>XML Spreadsheet 2003</td>
</tr>
</table><h2>Elements and Attributes</h2><h3>Child Elements</h3><table>
<tr>
<th>Element</th>
<th>Description</th>
</tr>
<tr>
<td><a href="x2eleRange_FieldType_HV01105185.htm" id="HV01105185" lcid="">Range</a></td>
<td>Contains a relative address that specifies which column is to be used for each of the elements mapped from the XML document.</td>
</tr>
<tr>
<td><a href="x2eleXPath_FieldType_HV01105190.htm" id="HV01105190" lcid="">XPath</a></td>
<td>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.</td>
</tr>
<tr>
<td><a href="x2eleXSDType_HV01105191.htm" id="HV01105191" lcid="">XSDType</a></td>
<td>"Contains the data type of the element or attribute being mapped, using the data types from the W3C Schema specification."</td>
</tr>
<tr>
<td><a href="x2eleAggregate_HV01105172.htm" id="HV01105172" lcid="">Aggregate</a></td>
<td>Indicates the kind of aggregation to be done in the totals row.</td>
</tr>
<tr>
<td>ss:Cell</td>
<td>See external namespace.</td>
</tr>
<tr>
<td>x:DataValidation</td>
<td>See external namespace.</td>
</tr>
<tr>
<td>x:AutoFilterColumn</td>
<td>See external namespace.</td>
</tr>
</table><h3>Attributes</h3><table>
<tr>
<th>Attribute</th>
<th>Type</th>
<th>Required</th>
<th>Description</th>
<th>Possible Values</th>
</tr>
<tr>
<td>ID</td>
<td>xsd:string</td>
<td>optional</td>
<td>Specifies the column heading value.</td>
<td>See external namespace.</td>
</tr>
</table><h2>Definition</h2><pre>
<code>
<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>
</code>
</pre><center><a href="XMLSchemaCopyright_HV01147162.htm">©2003-2004 Microsoft Corporation. All rights reserved.</a>
Permission to copy, display and distribute this document is available at: <a
href="http://r.office.microsoft.com/r/rlidAWSContentRedir?AssetID=XT010988631033&CTT=11&Origin=HV011232471033"
target="_new">http://msdn.microsoft.com/library/en-us/odcXMLRef/html/odcXMLRefLegalNotice.asp</a></center></body></html>
|
