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="HV01104903"><META NAME="lcid" CONTENT="1033"><title>PublishObject 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>PublishObject element</h1><p>Contains the properties of a published item.</p><h2>Usage</h2><pre>
<code>
<PublishObject
HRef="xsd:string"
/>
</code>
</pre><h2>Element Information</h2><table>
<tr>
<td>
<b class="bterm">Element type</b>
</td>
<td>Anonymous</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="xelePublishObjects_HV01104904.htm" id="HV01104904" lcid="">PublishObjects</a></td>
<td>Contains information about all published items in a workbook.</td>
</tr>
</table><h3>Child Elements</h3><table>
<tr>
<th>Element</th>
<th>Description</th>
</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>
</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: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>
</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>
|
