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
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
|
<html dir="ltr"><head>
<META http-equiv="Content-Type" content="text/html; charset=UTF-8">
<META HTTP-EQUIV="assetid" CONTENT="HV01105141"><META NAME="lcid" CONTENT="1033"><title>TextWizardSettingsType 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>TextWizardSettingsType complexType</h1><p>Contains the Text Import Wizard settings.</p><h2>Type Information</h2><table>
<tr>
<td>
<b class="bterm">Namespace</b>
</td>
<td>urn:schemas-microsoft-com:office:excel</td>
</tr>
<tr>
<td>
<b class="bterm">Schema name</b>
</td>
<td>XML Spreadsheet 2000</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="xeleFormatSettings_HV01104621.htm" id="HV01104621" lcid="">FormatSettings</a></td>
<td>Contains format settings for the columns of imported text.</td>
</tr>
<tr>
<td><a href="xeleDelimiters_HV01104527.htm" id="HV01104527" lcid="">Delimiters</a></td>
<td>Contains the delimiters used to parse imported text.</td>
</tr>
<tr>
<td><a href="xeleCommandTextOrignal_HV01104488.htm" id="HV01104488" lcid="">Comma</a></td>
<td>Specifies whether the comma character is used as a delimiter when importing text.</td>
</tr>
<tr>
<td><a href="xeleConsecutive_HV01104497.htm" id="HV01104497" lcid="">Consecutive</a></td>
<td>Specifies whether consecutive delimiters are treated as one when importing text.</td>
</tr>
<tr>
<td><a href="xeleCustom_HV01104508.htm" id="HV01104508" lcid="">Custom</a></td>
<td>Contains a custom character to be used as a delimiter when importing text.</td>
</tr>
<tr>
<td><a href="xeleSemiColon_HV01104956.htm" id="HV01104956" lcid="">SemiColon</a></td>
<td>Specifies whether the semicolon character is used as a delimiter when importing text.</td>
</tr>
<tr>
<td><a href="xeleSpaceAbove_HV01104996.htm" id="HV01104996" lcid="">Space</a></td>
<td>Specifies whether the space character is used as a delimiter when importing text.</td>
</tr>
<tr>
<td><a href="xeleTabColorIndex_HV01105013.htm" id="HV01105013" lcid="">Tab</a></td>
<td>Specifies whether the tab character is used as a delimiter when importing text.</td>
</tr>
<tr>
<td><a href="xeleTextQualifier_HV01105020.htm" id="HV01105020" lcid="">TextQualifier</a></td>
<td>Contains the character to be used for identifying text when importing text data.</td>
</tr>
<tr>
<td><a href="xeleName_TextWizardSettingsType_HV01104766.htm" id="HV01104766" lcid="">Name</a></td>
<td>Contains the user-defined name of an object, range, or reference to another workbook, the location and name of a text file, or the built-in name of a range.</td>
</tr>
<tr>
<td><a href="xeleSource_TextWizardSettingsType_HV01104979.htm" id="HV01104979" lcid="">Source</a></td>
<td>Contains the name of a published item or range, or specifies the character set of a text data source.</td>
</tr>
<tr>
<td><a href="xeleStartRow_HV01105003.htm" id="HV01105003" lcid="">StartRow</a></td>
<td>Specifies the first row of a text data source to begin text import.</td>
</tr>
<tr>
<td><a href="xeleDecimal_HV01104521.htm" id="HV01104521" lcid="">Decimal</a></td>
<td>Contains the decimal separator character used to recognize numeric data when importing text.</td>
</tr>
<tr>
<td><a href="xeleThousandSeparator_HV01105022.htm" id="HV01105022" lcid="">ThousandSeparator</a></td>
<td>Contains the thousands separator character used to recognize numeric data when importing text.</td>
</tr>
</table><h3>Attributes</h3><p>None.</p><h2>Definition</h2><pre>
<code>
<xsd:complexType name="TextWizardSettingsType" >
<xsd:sequence>
<xsd:element name="FormatSettings" type="FormatSettingsType">
</xsd:element>
<xsd:element name="Delimiters">
<xsd:complexType>
<xsd:sequence>
<xsd:element name="Comma" minOccurs="0">
</xsd:element>
<xsd:element name="Consecutive" minOccurs="0">
</xsd:element>
<xsd:element name="Custom" type="xsd:string" minOccurs="0">
</xsd:element>
<xsd:element name="SemiColon" minOccurs="0">
</xsd:element>
<xsd:element name="Space" minOccurs="0">
</xsd:element>
<xsd:element name="Tab" minOccurs="0">
</xsd:element>
<xsd:element name="TextQualifier" default="Quote" minOccurs="0">
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:enumeration value="None" />
<xsd:enumeration value="Quote" />
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
</xsd:sequence>
</xsd:complexType>
</xsd:element>
<xsd:element name="Name" type="xsd:string">
</xsd:element>
<xsd:element name="Source" default="ANSI">
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:enumeration value="ANSI" />
<xsd:enumeration value="MAC" />
<xsd:enumeration value="PC8" />
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element name="StartRow" type="xsd:int" default="1">
</xsd:element>
<xsd:element name="Decimal" type="xsd:string">
</xsd:element>
<xsd:element name="ThousandSeparator" type="xsd:string">
</xsd:element>
</xsd:sequence>
</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>
|
