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

sheetDataSet (§3.14.14)

 

Child Elements	Subclause
row (Row)	§3.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 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 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>