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
|
<html dir="ltr"><head>
<META http-equiv="Content-Type" content="text/html; charset=UTF-8">
<META HTTP-EQUIV="assetid" CONTENT="HV01104928"><META NAME="lcid" CONTENT="1033"><title>RefreshInfo element (QueryTableType 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>RefreshInfo element (QueryTableType complexType)</h1><p>Contains information to be used when data is refreshed.</p><h2>Usage</h2><pre>
<code>
<RefreshInfo />
</code>
</pre><h2>Element Information</h2><table>
<tr>
<td>
<b class="bterm">Element type</b>
</td>
<td><a href="xtcoRefreshInfoType_HV01105134.htm" id="HV01105134" lcid="">RefreshInfoType</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>Parent Elements</h3><table>
<tr>
<th>Element</th>
<th>Description</th>
</tr>
<tr>
<td><a href="xeleQueryTable_HV01104912.htm" id="HV01104912" lcid="">QueryTable</a></td>
<td>Contains information about a section of the spreadsheet that holds the results of a query.</td>
</tr>
</table><h3>Child Elements</h3><table>
<tr>
<th>Element</th>
<th>Description</th>
</tr>
<tr>
<td><a href="xeleNextId_HV01104772.htm" id="HV01104772" lcid="">NextId</a></td>
<td>Specifies the next available unique identification number that can be assigned to a column.</td>
</tr>
<tr>
<td><a href="xeleColumnInfo_HV01104482.htm" id="HV01104482" lcid="">ColumnInfo</a></td>
<td>Contains information about a column.</td>
</tr>
<tr>
<td><a href="xeleDoNotPersist_RefreshInfoType_HV01104566.htm" id="HV01104566" lcid="">DoNotPersist</a></td>
<td>Specifies whether to preserve sort and filter settings for a column.</td>
</tr>
<tr>
<td><a href="xeleDoNotPersistSort_HV01104568.htm" id="HV01104568" lcid="">DoNotPersistSort</a></td>
<td>Specifies whether sort settings are preserved for a column.</td>
</tr>
<tr>
<td><a href="xeleDoNotPersstAF_HV01104569.htm" id="HV01104569" lcid="">DoNotPersstAF</a></td>
<td>Specifies whether filter settings are preserved for a column.</td>
</tr>
<tr>
<td><a href="xeleSort_RefreshInfoType_HV01104973.htm" id="HV01104973" lcid="">Sort</a></td>
<td>Specifies a range of cells or the name of a range to sort, or whether a query table has been sorted.</td>
</tr>
<tr>
<td><a href="xeleCaseSensitive_RefreshInfoType_HV01104465.htm" id="HV01104465" lcid="">CaseSensitive</a></td>
<td>Specifies whether sorting is case-sensitive.</td>
</tr>
<tr>
<td><a href="xeleFuturePersist_HV01104640.htm" id="HV01104640" lcid="">FuturePersist</a></td>
<td>Reserved for future use.</td>
</tr>
<tr>
<td><a href="xeleHeaderRow_HV01104661.htm" id="HV01104661" lcid="">HeaderRow</a></td>
<td>Specifies whether the header row is included in a sort.</td>
</tr>
<tr>
<td><a href="xeleIdWrapped_HV01104681.htm" id="HV01104681" lcid="">IdWrapped</a></td>
<td>Specifies whether all possible identification numbers assigned to columns have been used and whether previously used numbers are being implemented.</td>
</tr>
<tr>
<td><a href="xeleNoTitles_RefreshInfoType_HV01104808.htm" id="HV01104808" lcid="">NoTitles</a></td>
<td>Specifies whether column titles are included in a query.</td>
</tr>
<tr>
<td><a href="xeleAlertVersion_HV01104392.htm" id="HV01104392" lcid="">AlertVersion</a></td>
<td>Reserved for future use.</td>
</tr>
<tr>
<td><a href="xeleSortOrder_HV01104977.htm" id="HV01104977" lcid="">SortOrder</a></td>
<td>Specifies the index number of a sort order used in a custom sort.</td>
</tr>
<tr>
<td><a href="xeleExtraLeftColumns_HV01104598.htm" id="HV01104598" lcid="">ExtraLeftColumns</a></td>
<td>Specifies the number of columns to the left of a query table included in a sort.</td>
</tr>
<tr>
<td><a href="xeleExtraRightColumns_HV01104599.htm" id="HV01104599" lcid="">ExtraRightColumns</a></td>
<td>Specifies the number of columns to the right of a query table included in a sort.</td>
</tr>
<tr>
<td><a href="xeleDeletedTitle_HV01104526.htm" id="HV01104526" lcid="">DeletedTitle</a></td>
<td>Contains the column title deleted from a query.</td>
</tr>
</table><h3>Attributes</h3><p>None.</p><h2>Definition</h2><pre>
<code>
<xsd:element name="RefreshInfo" type="RefreshInfoType" minOccurs="0" >
</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>
|
