2.3.1 CT_WorkbookOptions

  • Article

Referenced by: CT_Workbook

A collection of settings for the workbook.

Child Elements:

HideWorkbookTabs: Specifies whether sheet tabs are hidden. This element MUST be present if the sheet tabs on the workbook are hidden. This element MUST NOT be present if the sheet tabs are not hidden.

HidePivotFieldList: Specifies whether the PivotTable field list in the workbook is hidden. This element MUST be present if the field list is hidden for the workbook and MUST NOT be present otherwise.

HideSlicerPane: Specifies whether the slicer pane is hidden.

InteractiveReportUsingExternalData: Specifies whether an interactive report is using an external data connection.

enableRefresh: Indicates whether external data connection in the workbook can be refreshed.

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

 <xs:complexType name="CT_WorkbookOptions">
   <xs:sequence>
     <xs:element name="HideWorkbookTabs" minOccurs="0" maxOccurs="1"/>
     <xs:element name="HidePivotFieldList" minOccurs="0" maxOccurs="1"/>
     <xs:element name="HideSlicerPane" minOccurs="0" maxOccurs="1"/>
     <xs:element name="InteractiveReportUsingExternalData" minOccurs="0" maxOccurs="1"/>
     <xs:element name="enableRefresh" minOccurs="0" maxOccurs="1"/>
   </xs:sequence>
 </xs:complexType>

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