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
137
138
139
|
<html dir="ltr"><head>
<META http-equiv="Content-Type" content="text/html; charset=UTF-8">
<META HTTP-EQUIV="assetid" CONTENT="HV01105224"><META NAME="lcid" CONTENT="1033"><title>Worksheet 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>Worksheet element</h1><p>Defines a worksheet within the current workbook. At least one instance of this element is required for a valid XML spreadsheet.</p><h2>Usage</h2><pre>
<code>
<Worksheet
Name="xsd:string"
Protected="TrueFalseType"
RightToLeft="TrueFalseType"
/>
</code>
</pre><h2>Element Information</h2><table>
<tr>
<td>
<b class="bterm">Element type</b>
</td>
<td><a href="sstcoWorksheetType_HV01105236.htm" id="HV01105236" lcid="">WorksheetType</a></td>
</tr>
<tr>
<td>
<b class="bterm">Namespace</b>
</td>
<td>urn:schemas-microsoft-com:office:spreadsheet</td>
</tr>
<tr>
<td>
<b class="bterm">Schema name</b>
</td>
<td>XML Spreadsheet 2002</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="sseleWorkbook_HV01105223.htm" id="HV01105223" lcid="">Workbook</a>
</td>
<td>Defines a workbook that will contain one or more Worksheet elements.</td>
</tr>
</table><h3>Child Elements</h3><table>
<tr>
<th>Element</th>
<th>Description</th>
</tr>
<tr>
<td><a href="sseleNames_WorksheetType_HV01105216.htm" id="HV01105216" lcid="">Names</a></td>
<td>Defines a collection of named ranges within a workbook or worksheet.</td>
</tr>
<tr>
<td><a href="sseleTable_HV01105222.htm" id="HV01105222" lcid="">Table</a></td>
<td>Defines the table to contain the cells of the current worksheet. Only one instance of a Table element is valid for a single worksheet.</td>
</tr>
<tr>
<td>x:WorksheetOptions</td>
<td>See external namespace.</td>
</tr>
<tr>
<td>x:Watches</td>
<td>See external namespace.</td>
</tr>
<tr>
<td>x:DataTable</td>
<td>See external namespace.</td>
</tr>
<tr>
<td>x:PageBreaks</td>
<td>See external namespace.</td>
</tr>
<tr>
<td>x:PivotTable</td>
<td>See external namespace.</td>
</tr>
<tr>
<td>x:DataValidation</td>
<td>See external namespace.</td>
</tr>
<tr>
<td>x:AutoFilter</td>
<td>See external namespace.</td>
</tr>
<tr>
<td>x:ConditionalFormatting</td>
<td>See external namespace.</td>
</tr>
<tr>
<td>x:Sorting</td>
<td>See external namespace.</td>
</tr>
<tr>
<td>c:worksheetoptions</td>
<td>See external namespace.</td>
</tr>
<tr>
<td>x:QueryTable</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>Name</td>
<td>xsd:string</td>
<td>required</td>
<td>Specifies the name of a worksheet. This value must be unique within the list of worksheet names of a given workbook.</td>
<td>See external namespace.</td>
</tr>
<tr>
<td>Protected</td>
<td><a href="sstsiTrueFalseType_HV01105240.htm" id="HV01105240" lcid="">TrueFalseType</a></td>
<td>optional</td>
<td>Specifies whether a worksheet is protected. When protection is not enabled for a worksheet, protection settings for individual cells have no effect.</td>
<td><ul><li>0</li><li>1</li></ul></td>
</tr>
<tr>
<td>RightToLeft</td>
<td><a href="sstsiTrueFalseType_HV01105240.htm" id="HV01105240" lcid="">TrueFalseType</a></td>
<td>optional</td>
<td>Specifies whether the worksheet window displays information from left to right or from right to left. If this attribute is set to display from right to left, column A in a worksheet is the first column on the right.</td>
<td><ul><li>0</li><li>1</li></ul></td>
</tr>
</table><h2>Definition</h2><pre>
<code>
<xsd:element name="Worksheet" type="WorksheetType" minOccurs="0" maxOccurs="unbounded" >
</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>
|
