sheets (Sheets)

This element represents the collection of sheets in the workbook. There are different types of sheets you can create in SpreadsheetML. The most common sheet type is a worksheet; also called a spreadsheet. A worksheet is the primary document that you use in SpreadsheetML to store and work with data. A worksheet consists of cells that are organized into columns and rows.

Some workbooks might have a modular design where there is one sheet for data and another worksheet for each type of analysis. In a complex modular system, you might have dozens of sheets, each dedicated to a specific task.

[Example:

<sheets>
<sheet name="Sheet1" sheetId="1" r:id="rId1"/>
<sheet name="Sheet2" sheetId="2" r:id="rId2"/>
<sheet name="Sheet5" sheetId="3" r:id="rId3"/>
<sheet name="Chart1" sheetId="4" type="chartsheet" r:id="rId4"/>
</sheets>

end example]

 

Parent Elements

workbook (§3.2.27)

 

Child Elements	Subclause
sheet (Sheet Information)	§3.2.19

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

<complexType name="CT_Sheets">

   <sequence>

   <element name="sheet" type="CT_Sheet" minOccurs="1" maxOccurs="unbounded"/>

   </sequence>

</complexType>