2.3.56 CT_Workbook

  • Article

Referenced by: Workbook

Specifies a workbook.

Child Elements:

WorkbookOptions:  A collection of settings for the workbook.

Parameters:  List of workbook parameters as specified in CT_Parameters. If there are no workbook parameters, this element MUST NOT be present.

NamedObjects:  List of named objects as specified in CT_NamedObjects. If there are no named objects, this element MUST NOT be present

Styles: An unordered collection of CT_Style elements as specified in CT_Styles. MUST NOT be present when one of the following conditions is true:

  • The requested range is a chart sheet.

  • The requested range is a named object containing a single chart, and a border is not specified.

Worksheet: A sheet or a named object in the workbook. When this element represents a sheet, there MUST be an entry for every published sheet in the workbook and the order of entries MUST be the same as in the workbook. In named object view mode, there MUST be a single Worksheet element representing the named object.

WebExtensions: Specifies all active Office Web Extensions in the workbook.

SurveyInformation: A CT_SurveyInformation element that specifies information about a survey in this workbook.  If there are no surveys in this workbook, this element MUST NOT be present.

The following W3C XML Schema ([XMLSCHEMA1] section 2.1) fragment specifies the contents of this complex type.

 <xs:complexType name="CT_Workbook" final="restriction">
   <xs:sequence>
     <xs:element name="WorkbookOptions" type="CT_WorkbookOptions"/>
     <xs:element name="Parameters" maxOccurs="1" minOccurs="0" type="CT_Parameters"/>
     <xs:element name="NamedObjects" minOccurs="0" maxOccurs="1" type="CT_NamedObjects"/>
     <xs:element name="Styles" minOccurs="0" maxOccurs="1" type="CT_Styles"/>
     <xs:element name="Worksheet" minOccurs="1" maxOccurs="unbounded" type="CT_Worksheet"/>
     <xs:element name="WebExtensions" maxOccurs="1" minOccurs="0" type="CT_WebExtensions"/>
     <xs:element name="SurveyInformation" type="CT_SurveyInformation" minOccurs="0" maxOccurs="1"/>
   </xs:sequence>
 </xs:complexType>

See section 5.1 for the full W3C XML Schema ([XMLSCHEMA1] section 2.1).