[Table of Contents] [docx version]

SpreadsheetML Reference Material - Table of Contents

sheet (Sheet Information)

This element defines a sheet in this workbook. Sheet data is stored in a separate part.

Parent Elements

sheets3.2.20)

 

Attributes

Description

id (Relationship Id)

 

Namespace: .../officeDocument/2006/relationships

Specifies the identifier of the sheet part where the definition for this sheet is stored.

 

This attribute is required.

 

The possible values for this attribute are defined by the ST_RelationshipId simple type (§7.8.2.1).

name (Sheet Name)

Specifies the name of the sheet. This name must be unique.

 

This attribute is required.

 

The possible values for this attribute are defined by the ST_Xstring simple type (§3.18.96).

sheetId (Sheet Tab Id)

Specifies the internal identifier for the sheet. This identifier must be unique.

 

This attribute is required.

 

The possible values for this attribute are defined by the XML Schema unsignedInt datatype.

state (Visible State)

Specifies the visible state of this sheet.

 

The default value for this attribute is "visible."

 

The possible values for this attribute are defined by the ST_SheetState simple type (§3.18.70).

The following XML Schema fragment defines the contents of this element:

<complexType name="CT_Sheet">

   <attribute name="name" type="ST_Xstring" use="required"/>

   <attribute name="sheetId" type="xsd:unsignedInt" use="required"/>

   <attribute name="state" type="ST_SheetState" use="optional" default="visible"/>

   <attribute ref="r:id" use="required"/>

</complexType>