Shared String Table Part

Content Type:

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

Root Namespace:

http://schemas.openxmlformats.org/spreadsheetml/2006/main

Source Relationship:

http://schemas.openxmlformats.org/officeDocument/2006/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:

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

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

example:

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

A Shared String Table part shall be located within the package containing the source relationship (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 this Standard.