[Table of Contents] [docx version]

SpreadsheetML Reference Material - Table of Contents

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

sheetDataSet3.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>