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
|
<html dir="ltr"><head>
<META http-equiv="Content-Type" content="text/html; charset=UTF-8">
<META HTTP-EQUIV="assetid" CONTENT="HV01105130"><META NAME="lcid" CONTENT="1033"><title>PublishObjectsType 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>PublishObjectsType complexType</h1><p>Contains information about all published items in a workbook.</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="xelePublishObjects_HV01104904.htm" id="HV01104904" lcid="">PublishObject</a></td>
<td>Contains the properties of a published item.</td>
</tr>
<tr>
<td><a href="xeleId_PublishObject_HV01104680.htm" id="HV01104680" lcid="">Id</a></td>
<td>Contains a unique identifier assigned to a column or, when the page is saved as a Web page, to a cell range.</td>
</tr>
<tr>
<td><a href="xeleDivID_PublishObject_HV01104557.htm" id="HV01104557" lcid="">DivID</a></td>
<td>Contains the unique identifier used to identify an HTML DIV element on a Web page. The element is associated with an item in a document that is published to a Web page. The item can be an entire workbook, a worksheet, a selected print range, an AutoFilter range, a range of cells, a chart, a PivotTable report, or a query table.</td>
</tr>
<tr>
<td><a href="xeleSourceType_HV01104994.htm" id="HV01104994" lcid="">SourceType</a></td>
<td>Specifies the type of item being published.</td>
</tr>
<tr>
<td><a href="xeleSource_PublishObject_HV01104978.htm" id="HV01104978" 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="xeleHtmlType_HV01104678.htm" id="HV01104678" lcid="">HtmlType</a></td>
<td>Specifies the type of HTML generated and the component used by Microsoft Excel when an item is published to a Web page.</td>
</tr>
<tr>
<td><a href="xeleLocation_PublishObject_HV01104723.htm" id="HV01104723" lcid="">Location</a></td>
<td>Contains an A1-style reference to a range in the worksheet containing a PivotTable report, or contains the URL (on the intranet or the Web) or path (local or network) to the location where a published item is saved.</td>
</tr>
<tr>
<td><a href="xeleAutoRepublish_HV01104429.htm" id="HV01104429" lcid="">AutoRepublish</a></td>
<td>Specifies where in the HTML document to place the published objects.</td>
</tr>
<tr>
<td><a href="xeleDivID_AutoRepublish_HV01104556.htm" id="HV01104556" lcid="">DivID</a></td>
<td>Contains the unique identifier used to identify an HTML DIV element on a Web page. The element is associated with an item in a document that is published to a Web page. The item can be an entire workbook, a worksheet, a selected print range, an AutoFilter range, a range of cells, a chart, a PivotTable report, or a query table.</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>HRef</td>
<td>xsd:string</td>
<td>required</td>
<td>Specifies the URL (on the intranet or the Web) or path (local or network) to the location where a published item is saved.</td>
<td>See external namespace.</td>
</tr>
</table><h2>Definition</h2><pre>
<code>
<xsd:complexType name="PublishObjectsType" >
<xsd:sequence>
<xsd:element name="PublishObject" maxOccurs="unbounded">
<xsd:complexType>
<xsd:sequence>
<xsd:element name="Id" type="xsd:long">
</xsd:element>
<xsd:element name="DivID" type="xsd:string">
</xsd:element>
<xsd:element name="SourceType">
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:enumeration value="AutoFilter" />
<xsd:enumeration value="PivotTable" />
<xsd:enumeration value="PrintArea" />
<xsd:enumeration value="Query" />
<xsd:enumeration value="Range" />
<xsd:enumeration value="Sheet" />
<xsd:enumeration value="SourceChart" />
<xsd:enumeration value="Workbook" />
<xsd:enumeration value="SourceWorkbook" />
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element name="Source" minOccurs="0">
</xsd:element>
<xsd:element name="HtmlType" default="StaticHTML">
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:enumeration value="PivotList" />
<xsd:enumeration value="StaticHTML" />
<xsd:enumeration value="WebCalc" />
<xsd:enumeration value="HTMLChart" />
<xsd:enumeration value="HtmlCalc" />
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element name="Location">
<xsd:complexType>
<xsd:attribute name="HRef" type="xsd:string" form="qualified" use="required">
</xsd:attribute>
</xsd:complexType>
</xsd:element>
</xsd:sequence>
</xsd:complexType>
</xsd:element>
<xsd:element name="AutoRepublish" minOccurs="0">
<xsd:complexType>
<xsd:sequence>
<xsd:element name="DivID" type="xsd:string" maxOccurs="unbounded">
</xsd:element>
</xsd:sequence>
</xsd:complexType>
</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>
|
