Single Cell Table Definitions Part

Content Type:

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

Root Namespace:

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

Source Relationship:

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

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:

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

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

example:

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

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.