12.3.15 Shared String Table Part

Content Type:

application/vnd.openxmlformats-officedocument.spreadsheetml.sharedStrings+xml

Root Namespace:

http://purl.oclc.org/ooxml/spreadsheetml/main

Source Relationship:

http://purl.oclc.org/ooxml/officeDocument/relationships/sharedStrings

An instance of this part type contains one occurrence of each unique string that occurs on all worksheets in a workbook.

A package shall contain exactly one Shared String Table part, and that part shall be the target of an implicit relationship from the Workbook part (12.3.23).

[Example: The following Workbook part-relationship item contains a relationship to the Shared String Table part, which is stored in the ZIP item sharedStrings.xml:

<Relationships xmlns="…">
  <Relationship Id="rId6"
    Type="http://…/sharedStrings" Target="sharedStrings.xml"/>
</Relationships>

end example]

The root element for a part of this content type shall be sst.

[Example: Here are three of the six strings used in the worksheets:

<sst xmlns:st="…" … totalCount="6" uniqueCount="6">
  <sstItem>
    <t>Expenses Log</t>
  </sstItem>
  <sstItem>
    <t>Period Start</t>
  </sstItem>
  <sstItem>
    <t>Period End</t>
  </sstItem>
  …
</sst>

end example]

A Shared String Table part shall be located within the package containing the relationships part (expressed syntactically, the TargetMode attribute of the Relationship element shall be Internal).

A Shared String Table part shall not have implicit or explicit relationships to any other part defined by ISO/IEC 29500.