Workbook element

Defines a workbook that will contain one or more Worksheet elements.

Usage

      
<Workbook />

    

Element Information

Element type Anonymous
Namespace urn:schemas-microsoft-com:office:spreadsheet
Schema name XML Spreadsheet 2002

Elements and Attributes

Child Elements

Element Description
Styles Contains the style definitions for the current worksheet. This element is required for custom formatting; otherwise, it is optional.
Style Defines a single style in the current workbook. This element is required for custom formatting; otherwise, it is optional.
Names Defines the collection of named ranges within a workbook.
Worksheet Defines a worksheet within the current workbook. At least one instance of this element is required for a valid XML spreadsheet.
o:SmartTagType See external namespace.
o:DocumentProperties See external namespace.
o:CustomDocumentProperties See external namespace.
o:OfficeDocumentSettings See external namespace.
x:ExcelWorkbook See external namespace.
x:PivotCache See external namespace.
x:Name See external namespace.
x2:MapInfo See external namespace.
x2:Binding See external namespace.
c:ComponentOptions See external namespace.

Attributes

None.

Definition

      
<xsd:element name="Workbook" >
  <xsd:complexType>
    <xsd:sequence>
      <xsd:element ref="o:SmartTagType" minOccurs="0" maxOccurs="unbounded" />
      <xsd:element ref="o:DocumentProperties" minOccurs="0" />
      <xsd:element ref="o:CustomDocumentProperties" minOccurs="0" />
      <xsd:element ref="o:OfficeDocumentSettings" minOccurs="0" />
      <xsd:element ref="x:ExcelWorkbook" minOccurs="0" />
      <xsd:element name="Styles" minOccurs="0">
        <xsd:complexType>
          <xsd:sequence>
            <xsd:element name="Style" type="StyleType" minOccurs="0" maxOccurs="unbounded">
            </xsd:element>
          </xsd:sequence>
        </xsd:complexType>
      </xsd:element>
      <xsd:element name="Names" type="NamesType" minOccurs="0">
      </xsd:element>
      <xsd:element name="Worksheet" type="WorksheetType" minOccurs="0" maxOccurs="unbounded">
      </xsd:element>
      <xsd:element ref="x:PivotCache" minOccurs="0" maxOccurs="unbounded" />
      <xsd:element ref="x:Name" minOccurs="0" />
      <xsd:element ref="x2:MapInfo" minOccurs="0" maxOccurs="unbounded" />
      <xsd:element ref="x2:Binding" minOccurs="0" maxOccurs="unbounded" />
      <xsd:element ref="c:ComponentOptions" minOccurs="0" />
    </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