DocumentID: ECMA-376/Part1/12.3.15
Title: ECMA-376, Part1: 12.3.15 Shared String Table Part
Extracted-From: ECMA-376 Office Open XML File Formats, 1st Edition / December 2006
Warning: Coverted to HTML format by a script known to have bugs

Navigation:

12.3.15 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: 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 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.


Converted to HTML format by ooxmlspec2html 0.1, a Perl script provided by OpenISO.org.