PublishObject element

Contains the properties of a published item.

Usage

      
<PublishObject
	HRef="xsd:string"
/>

    

Element Information

Element type Anonymous
Namespace urn:schemas-microsoft-com:office:excel
Schema name XML Spreadsheet 2000

Elements and Attributes

Parent Elements

Element Description
PublishObjects Contains information about all published items in a workbook.

Child Elements

Element Description
Id Contains a unique identifier assigned to a column or, when the page is saved as a Web page, to a cell range.
DivID 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.
SourceType Specifies the type of item being published.
Source Contains the name of a published item or range, or specifies the character set of a text data source.
HtmlType Specifies the type of HTML generated and the component used by Microsoft Excel when an item is published to a Web page.
Location 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.

Attributes

Attribute Type Required Description Possible Values
HRef xsd:string required Specifies the URL (on the intranet or the Web) or path (local or network) to the location where a published item is saved. See external namespace.

Definition

      
<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>


    
©2003-2004 Microsoft Corporation. All rights reserved. Permission to copy, display and distribute this document is available at: http://msdn.microsoft.com/library/en-us/odcXMLRef/html/odcXMLRefLegalNotice.asp