Excel: export to xml

[chiskop]

Right, hoping there is someone wise in the ways of excel 2007.

What I have is a simple table in the form:

name column2 column3 column4 column5​

which I want to export in the form:

<record1>

<name>Value</name>
<column2>Value</column2>
<column3>Value</column3>
<column4>Value</column4>
<column5>Value</column5>
​

</record1>​

So far, I have got my table, and my xml map, but all I seem to be able to export is the first row - a perfectly formed first row, but that's it.

What must the xml map look like? I used an empty version of the above - is that right?

Helps please.


Edit: Looking at it again - I think I need to map the record part of the map as a repeating element? How do I do that?