<c>
(Cell)
This collection represents a cell in the worksheet. Information about the cell's location (reference), value, data type, formatting, and formula is expressed here.
<c r="C6" s="1" vm="15"> <f>CUBEVALUE("xlextdat9 Adventure Works",C$5,$A6)</f> <v>2838512.355</v> </c>
While a cell can have a formula element <f>
and a value element <v>
, when the cell's type @t
is inlineStr
then only the element <is>
is allowed as a child element.
Here is an example of expressing a string in the cell rather than using the shared string table.
<row r="1" spans="1:1"> <c r="A1" t="inlineStr"> <is><t>This is inline string example</t></is> </c> </row>
Parent Elements |
---|
|
Child Elements |
Subclause |
---|---|
|
|
|
|
|
|
|
Attributes |
Description |
---|---|
|
The zero-based index of the cell metadata record associated with this cell. Metadata information is found in the Metadata Part. Cell metadata is extra information stored at the cell level, and is attached to the cell (travels through moves, copy / paste, clear, etc). Cell metadata is not accessible via formula reference. The possible values for this attribute are defined by the XML Schema unsignedInt datatype. |
|
A Boolean value indicating if the spreadsheet application should show phonetic information. Phonetic information is displayed in the same cell across the top of the cell and serves as a 'hint' which indicates how the text should be pronounced. This should only be used for East Asian languages. The possible values for this attribute are defined by the XML Schema boolean datatype. |
|
An A1 style reference to the location of this cell The possible values for this attribute are defined by the ST_CellRef simple type (§3.18.8). |
|
The index of this cell's style. Style records are stored in the Styles Part. The possible values for this attribute are defined by the XML Schema unsignedInt datatype. |
|
An enumeration representing the cell's data type. The possible values for this attribute are defined by the ST_CellType simple type (§3.18.12). |
|
The zero-based index of the value metadata record associated with this cell's value. Metadata records are stored in the Metadata Part. Value metadata is extra information stored at the cell level, but associated with the value rather than the cell itself. Value metadata is accessible via formula reference. 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_Cell">
<sequence>
<element name="f" type="CT_CellFormula" minOccurs="0" maxOccurs="1"/>
<element name="v" type="ST_Xstring" minOccurs="0" maxOccurs="1"/>
<element name="is" type="CT_Rst" minOccurs="0" maxOccurs="1"/>
<element name="extLst" minOccurs="0" type="CT_ExtensionList"/>
</sequence>
<attribute name="r" type="ST_CellRef" use="optional"/>
<attribute name="s" type="xsd:unsignedInt" use="optional" default="0"/>
<attribute name="t" type="ST_CellType" use="optional" default="n"/>
<attribute name="cm" type="xsd:unsignedInt" use="optional" default="0"/>
<attribute name="vm" type="xsd:unsignedInt" use="optional" default="0"/>
<attribute name="ph" type="xsd:boolean" use="optional" default="false"/>
</complexType>