SimpleXML为excel添加子项和属性

Question

I'n really new to this and my question should be simple. Lets say i have this xml:

    <?xml version="1.0"?>
    ....
        xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet"
    ....
    <Worksheet ss:Name="sheet1">
    ....
    <Worksheet ss:Name="sheet2">
    ....

How do i add in worksheet 1 a cell in row 5 looking like this:

    <Cell ss:Index="5" ss:StyleID="s22"><Data ss:Type="String">Some text</Data></Cell>

using SimpleXML? Anyone with sample of code, please.

Answer 1

First of all, you have to retrieve the node you need using a Location Path and then, after you construct the new element, you can use the method addchild.