<cell> (External Cell Data)

This element is used to store cached values from external sources such as other workbooks. Formulas from external cells are not stored in the consuming workbook. Also, for this context, the attribute @t cannot have a value of inlineStr. Rich text is not supported in this context either.

Parent Elements

<row> (§3.14.12)

Child Elements

Subclause

<v> (Cell Value)

§3.3.1.93

Attributes

Description

<r> (Reference)

Describes the cell location in the external book.

example: 
<cell r="B12">
  <v>74</v>
</cell>

The possible values for this attribute are defined by the ST_CellRef simple type (§3.18.8).

<t> (Type)

Indicates the data type of the cell value.

The possible values for this attribute are defined by the ST_CellType simple type (§3.18.12).

<vm> (Value Metadata)

The index of the cell's value metadata, if any exists.

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_ExternalCell">
	<sequence>
	<element name="v" type="ST_Xstring" minOccurs="0" maxOccurs="1"/>
	</sequence>
	<attribute name="r" type="ST_CellRef" use="optional"/>
	<attribute name="t" type="ST_CellType" use="optional" default="n"/>
	<attribute name="vm" type="xsd:unsignedInt" use="optional" default="0"/>
</complexType>