PublishObjectsType complexType

Contains information about all published items in a workbook.

Type Information

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

Elements and Attributes

Child Elements

Element Description
PublishObject Contains the properties of a published item.
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.
AutoRepublish Specifies where in the HTML document to place the published objects.
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.

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


    
©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