12.3.19 Single Cell Table Definitions Part

Content Type:

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

Root Namespace:

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

Source Relationship:

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

An instance of this part type contains information on how to map non-repeating elements from a custom XML file into cells in a worksheet. [Note: Repeating custom XML elements are mapped using a Table (12.3.21). end note]

A package shall contain at most one Single Cell Table Definitions part per worksheet, and that part shall be the target of an implicit relationship from a Worksheet (12.3.24) part. A Single Cell Table Definitions part can describe one or more single cell table definitions for any given worksheet.

[Example: The following Worksheet part-relationship item contains a relationship to the Single Cell Table Definitions part, which is stored in the ZIP item ../tables/tableSingleCells1.xml:

<Relationships xmlns="…">
  <Relationship Id="rId1"
    Type="http://…/tableSingleCells"
    Target="../tables/tableSingleCells1.xml"/>
</Relationships>

end example]

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

[Example: A worksheet contains two single cell table definitions; e.g., ../tables/tableSingleCells1.xml contains the following, where the elements id and count are nested inside element names:

<singleXmlCells …>
  <singleCell id="1" name="Table1" displayName="Table1" ref="B4">
    <cellPr id="1" uniqueName="id">
      <xmlPr mapId="1" xpath="/names/id" xmlDataType="string"/>
    </cellPr>
  </singleCell>
  <singleCell id="2" name="Table2" displayName="Table2" ref="B7">
    <cellPr id="1" uniqueName="count">
      <xmlPr mapId="1" xpath="/names/count" xmlDataType="integer"/>
    </cellPr>
  </singleCell>
</singleXmlCells>

end example]

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

any other part defined by

A Single Cell Table Definitions part shall not have implicit or explicit relationships to ISO/IEC 29500.