ExternalSheetData Class
External Sheet Data Set.When the object is serialized out as xml, its qualified name is x:sheetData.
Inheritance Hierarchy
System.Object
DocumentFormat.OpenXml.OpenXmlElement
DocumentFormat.OpenXml.OpenXmlCompositeElement
DocumentFormat.OpenXml.Spreadsheet.ExternalSheetData
Namespace: DocumentFormat.OpenXml.Spreadsheet
Assembly: DocumentFormat.OpenXml (in DocumentFormat.OpenXml.dll)
Syntax
'Declaration
<ChildElementInfoAttribute(GetType(ExternalRow))> _
Public Class ExternalSheetData _
Inherits OpenXmlCompositeElement
'Usage
Dim instance As ExternalSheetData
[ChildElementInfoAttribute(typeof(ExternalRow))]
public class ExternalSheetData : OpenXmlCompositeElement
Remarks
The following table lists the possible child types:
- ExternalRow <x:row>
[ISO/IEC 29500-1 1st Edition]
18.14.13 sheetData (External Sheet Data Set)
This element contains the cached worksheet data associated with a supporting workbook.
[Note: For an example, please refer to example at the beginning of this section. end note]
Parent Elements |
|---|
sheetDataSet (§18.14.14) |
Child Elements |
Subclause |
|---|---|
row (Row) |
§18.14.12 |
Attributes |
Description |
|---|---|
refreshError (Last Refresh Resulted in Error) |
Specifies that the last external data refresh for this sheet did not succeed. The possible values for this attribute are defined by the W3C XML Schema boolean datatype. |
sheetId (Sheet Id) |
Index of sheet in the external workbook that is referenced and partially cached in this data set. This is a 1-based index. This attribute is required. The possible values for this attribute are defined by the W3C XML Schema unsignedInt datatype. |
[Note: The W3C XML Schema definition of this element’s content model (CT_ExternalSheetData) 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.