DocumentID: ECMA-376/Part1/12.3.19
Title: ECMA-376, Part1: 12.3.19 Single Cell Table Definitions 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

• Next: 12.3.20 Styles Part
• Up: 12.3 Part Summary
• Table of contents: Table of contents
• Previous: 12.3.18 Shared Workbook User Data Part

12.3.19 Single Cell Table Definitions Part

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

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

<singleCells ...>
  <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>
</singleCells>

end example]

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

A Single Cell Table Definitions part shall not have implicit or explicit relationships to any other part defined by this Standard.