L.2.15.4.4 Single Cell XML

L.2.2 Sheets

Contents of tableSingleCells.xml

<singleXmlCells xmlns="http://purl.oclc.org/ooxml/spreadsheetml/main">
  <singleXmlCell id="1" name="Table1" displayName="Table1" r="B3"
connectionId="1">
    <xmlCellPr id="1" uniqueName="currency">
      <xmlPr mapId="1" xpath="/expense-report/@currency"
xmlDataType="string"/>
    </xmlCellPr>
  </singleXmlCell>
  <singleXmlCell id="2" name="Table2" displayName="Table2" r="C3"
connectionId="1">
    <xmlCellPr id="1" uniqueName="detailed">
      <xmlPr mapId="1" xpath="/expense-report/@detailed"
xmlDataType="boolean"/>
    </xmlCellPr>
  </singleXmlCell>
  <singleXmlCell id="3" name="Table3" displayName="Table3" r="D3"
connectionId="1">
    <xmlCellPr id="1" uniqueName="total-sum">
      <xmlPr mapId="1" xpath="/expense-report/@total-sum"
xmlDataType="double"/>
    </xmlCellPr>
  </singleXmlCell>
  <singleXmlCell id="4" name="Table4" displayName="Table4" r="B6"
connectionId="1">
    <xmlCellPr id="1" uniqueName="First">
      <xmlPr mapId="1" xpath="/expense-report/Person/First"
xmlDataType="string"/>
    </xmlCellPr>
  </singleXmlCell>
  <singleXmlCell id="5" name="Table5" displayName="Table5" r="C6"
connectionId="1">
    <xmlCellPr id="1" uniqueName="Last">
      <xmlPr mapId="1" xpath="/expense-report/Person/Last"
xmlDataType="string"/>
    </xmlCellPr>
  </singleXmlCell>
  <singleXmlCell id="6" name="Table6" displayName="Table6" r="D6"
connectionId="1">
    <xmlCellPr id="1" uniqueName="Email">
      <xmlPr mapId="1" xpath="/expense-report/Person/Email"
xmlDataType="string"/>
    </xmlCellPr>
  </singleXmlCell>
</singleXmlCells>

A single cell which has been mapped to an XML node is expressed in much the same way that an entire table is expressed.

The question.

collection is the top level object, like the Table, which identifies

the cell in

The collection identifies the name for the only ‘column’ in this structure, the single cell. In this way it is much like a table column definition and the table column-level properties.

The collection expresses the xml properties for this cell.

Last updated on March 14, 2025

L.2.15.4 Example L.2.16.4 Cell References