<sst> (Shared String Table)

This element is the root of the <Shared String> Table, which serves as a collection of individual <String Items (si).>

Parent Elements

Root element of SpreadsheetML Shared String Table part

Child Elements

Subclause

<extLst> (Future Feature Data Storage Area)

§3.2.10

<si> (String Item)

§3.4.8

Attributes

Description

<count> (String Count)

An integer representing the total count of strings in the workbook. This count does not include any numbers, it counts only the total of text strings in the workbook.

This attribute is optional unless uniqueCount is used, in which case it is required.

The possible values for this attribute are defined by the XML Schema unsignedInt datatype.

<uniqueCount> (Unique String Count)

An integer representing the total count of unique strings in the <Shared String> Table. A string is unique even if it is a copy of another string, but has different formatting applied at the character level.

example:

World, World, and World.

The count would be 3, and the uniqueCount would be 2. Only one entry for "World" would show in the table because it is the same string, just with different formatting applied at the cell level (i.e., applied to the entire string in the cell). The "World" string would get a separate unique entry in the shared string table because it has different formatting applied to specific characters.

This attribute is optional unless count is used, in which case it 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_Sst">
	<sequence>
	<element name="si" type="CT_Rst" minOccurs="0" maxOccurs="unbounded"/>
	<element name="extLst" minOccurs="0" type="CT_ExtensionList"/>
	</sequence>
	<attribute name="count" type="xsd:unsignedInt" use="optional"/>
	<attribute name="uniqueCount" type="xsd:unsignedInt" use="optional"/>
</complexType>