<sheetData>
(External Sheet Data Set)
This element contains the cached worksheet data associated with a supporting workbook.
For an example, please refer to example at the beginning of this section.
Parent Elements |
---|
|
Child Elements |
Subclause |
---|---|
|
Attributes |
Description |
---|---|
|
Specifies that the last external data refresh for this sheet did not succeed. The possible values for this attribute are defined by the XML Schema boolean datatype. |
|
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 XML Schema unsignedInt datatype. |
The following XML Schema fragment defines the contents of this element:
<complexType name="CT_ExternalSheetData">
<sequence>
<element name="row" type="CT_ExternalRow" minOccurs="0" maxOccurs="unbounded"/>
</sequence>
<attribute name="sheetId" type="xsd:unsignedInt" use="required"/>
<attribute name="refreshError" type="xsd:boolean" use="optional" default="false"/>
</complexType>