Single Cell XML

Contents of tableSingleCells.xml

<singleXmlCells xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/5/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 <singleXmlCell> collection is the top level object, like the Table, which identifies the cell in question.

The <xmlCellPr> 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 <xmlPr> collection expresses the xml properties for this cell.