Sheets Class
Sheets.When the object is serialized out as xml, its qualified name is x:sheets.
Inheritance Hierarchy
System.Object
DocumentFormat.OpenXml.OpenXmlElement
DocumentFormat.OpenXml.OpenXmlCompositeElement
DocumentFormat.OpenXml.Spreadsheet.Sheets
Namespace: DocumentFormat.OpenXml.Spreadsheet
Assembly: DocumentFormat.OpenXml (in DocumentFormat.OpenXml.dll)
Syntax
'Declaration
<ChildElementInfoAttribute(GetType(Sheet))> _
Public Class Sheets _
Inherits OpenXmlCompositeElement
'Usage
Dim instance As Sheets
[ChildElementInfoAttribute(typeof(Sheet))]
public class Sheets : OpenXmlCompositeElement
Remarks
The following table lists the possible child types:
- Sheet <x:sheet>
[ISO/IEC 29500-1 1st Edition]
18.2.20 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 specific analysis performed on that data. 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 (§18.2.27) |
Child Elements |
Subclause |
|---|---|
sheet (Sheet Information) |
§18.2.19 |
[Note: The W3C XML Schema definition of this element’s content model (CT_Sheets) is located in §A.2. end note]
© ISO/IEC29500: 2008.
Thread Safety
Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.