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
|
<html dir="ltr"><head>
<META http-equiv="Content-Type" content="text/html; charset=UTF-8">
<META HTTP-EQUIV="assetid" CONTENT="HV01104912"><META NAME="lcid" CONTENT="1033"><title>QueryTable element</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>QueryTable element</h1><p>Contains information about a section of the spreadsheet that holds the results of a query.</p><h2>Usage</h2><pre>
<code>
<QueryTable />
</code>
</pre><h2>Element Information</h2><table>
<tr>
<td>
<b class="bterm">Element type</b>
</td>
<td><a href="xtcoQueryTableType_HV01105133.htm" id="HV01105133" lcid="">QueryTableType</a></td>
</tr>
<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="xeleName_QueryTableType_HV01104765.htm" id="HV01104765" 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="xeleAutoFormatFont_QueryTableType_HV01104421.htm" id="HV01104421" lcid="">AutoFormatFont</a></td>
<td>Specifies whether the font is changed when a predefined format is applied.</td>
</tr>
<tr>
<td><a href="xeleAutoFormatName_QueryTableType_HV01104423.htm" id="HV01104423" lcid="">AutoFormatName</a></td>
<td>Contains the name of a predefined format.</td>
</tr>
<tr>
<td><a href="xeleAutoFormatNumber_QueryTableType_HV01104425.htm" id="HV01104425" lcid="">AutoFormatNumber</a></td>
<td>Specifies whether cell number formatting is changed when a predefined format is applied.</td>
</tr>
<tr>
<td><a href="xeleAutoFormatBorder_QueryTableType_HV01104419.htm" id="HV01104419" lcid="">AutoFormatBorder</a></td>
<td>Specifies whether the cell border is changed when a predefined format is applied.</td>
</tr>
<tr>
<td><a href="xeleAutoFormatPattern_QueryTableType_HV01104427.htm" id="HV01104427" lcid="">AutoFormatPattern</a></td>
<td>Specifies whether cell pattern formatting is changed when a predefined format is applied.</td>
</tr>
<tr>
<td><a href="xeleAutoFormatAlignment_QueryTableType_HV01104417.htm" id="HV01104417" lcid="">AutoFormatAlignment</a></td>
<td>Specifies whether cell alignment is adjusted when a predefined format is applied.</td>
</tr>
<tr>
<td><a href="xeleAutoFormatWidth_HV01104428.htm" id="HV01104428" lcid="">AutoFormatWidth</a></td>
<td>Specifies whether the cell width is changed when a predefined format is applied.</td>
</tr>
<tr>
<td><a href="xeleQuerySource_QueryTableType_HV01104911.htm" id="HV01104911" lcid="">QuerySource</a></td>
<td>Contains information about the data source of a query.</td>
</tr>
<tr>
<td><a href="xeleDisableEdit_HV01104542.htm" id="HV01104542" lcid="">DisableEdit</a></td>
<td>Specifies whether editing is allowed.</td>
</tr>
<tr>
<td><a href="xeleDisableRefresh_QueryTableType_HV01104545.htm" id="HV01104545" lcid="">DisableRefresh</a></td>
<td>Specifies whether refreshing and editing is enabled for a query table, or whether the cache for a PivotTable view can be refreshed by the user.</td>
</tr>
<tr>
<td><a href="xeleFilled_HV01104609.htm" id="HV01104609" lcid="">Filled</a></td>
<td>Specifies whether formulas to the right of a query table are included in new rows that are added to a query table when data is refreshed.</td>
</tr>
<tr>
<td><a href="xeleInsertEntireRows_HV01104688.htm" id="HV01104688" lcid="">InsertEntireRows</a></td>
<td>Specifies whether entire rows are inserted to accommodate new data when a query table is refreshed.</td>
</tr>
<tr>
<td><a href="xeleNewAsync_HV01104769.htm" id="HV01104769" lcid="">NewAsync</a></td>
<td>Indicates whether the workbook was saved while the data in a query table was being refreshed.</td>
</tr>
<tr>
<td><a href="xeleNoAutofit_HV01104773.htm" id="HV01104773" lcid="">NoAutofit</a></td>
<td>Specifies whether the column widths of a query table, or the height and width of a PivotList component, adjust to accommodate the data in visible columns and rows.</td>
</tr>
<tr>
<td><a href="xeleNoPreserveFormatting_QueryTableType_HV01104795.htm" id="HV01104795" lcid="">NoPreserveFormatting</a></td>
<td>Specifies whether formatting is preserved when data is refreshed.</td>
</tr>
<tr>
<td><a href="xeleNoSaveData_QueryTableType_HV01104802.htm" id="HV01104802" lcid="">NoSaveData</a></td>
<td>Specifies whether data from a query is saved when a workbook is saved.</td>
</tr>
<tr>
<td><a href="xeleNoTitles_QueryTableType_HV01104807.htm" id="HV01104807" lcid="">NoTitles</a></td>
<td>Specifies whether column titles are included in a query.</td>
</tr>
<tr>
<td><a href="xeleOverwriteCells_HV01104830.htm" id="HV01104830" lcid="">OverwriteCells</a></td>
<td>Specifies whether existing cells are used to accommodate new data when a query table is refreshed.</td>
</tr>
<tr>
<td><a href="xeleRefreshInfo_QueryTableType_HV01104928.htm" id="HV01104928" lcid="">RefreshInfo</a></td>
<td>Contains information to be used when data is refreshed.</td>
</tr>
<tr>
<td><a href="xeleRefreshOnFileOpen_QueryTableType_HV01104932.htm" id="HV01104932" lcid="">RefreshOnFileOpen</a></td>
<td>Specifies whether the data in a PivotTable cache or query table is refreshed when a workbook is opened.</td>
</tr>
<tr>
<td><a href="xeleRowNumbers_QueryTableType_HV01104946.htm" id="HV01104946" lcid="">RowNumbers</a></td>
<td>Specifies whether row numbers are included in a database query.</td>
</tr>
<tr>
<td><a href="xeleSynchronous_HV01105011.htm" id="HV01105011" lcid="">Synchronous</a></td>
<td>Specifies whether background queries are enabled.</td>
</tr>
</table><h3>Attributes</h3><p>None.</p><h2>Definition</h2><pre>
<code>
<xsd:element name="QueryTable" type="QueryTableType" >
</xsd:element>
</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>
|
