How to XML Map Repeating Rows?

[DaveLS]

I'm trying to map XML to a range of rows but, for some reason, Excel (2007)
is only mapping it to the first row of the range. I've created an XML file
and imported it. Then, I right-click on the root element and choose Map
Element. Excel asks "Where do you want to map the XML elements?" I click and
drag a range of contiguous cells and it updates the range in the little
dialog box. The range displayed include the full range of columns and rows so
I hit OK. But then Excel only shows the first row with the blue border. And
when I export it only exports the first row.

What am I doing wrong? I've done this before successfully with a slightly
different map and it was working fine. I can't figure out what I'm doing
wrong today.

David Salahi

 

[DaveLS]

OK, I figured out the answer to my own question. The problem was that the
sample XML that I created to define the XML map had only a single XML node.
You have to have at least two XML nodes or "records" in order to map the node
as a repeating element.

Dave

 

[Simon Motaung]

OK, I figured out the answer to my own question. The problem was that the
sample XML that I created to define the XML map had only a single XML node.
You have to have at least two XML nodes or "records" in order to map the node
as a repeating element.

Dave

Hi Dave,

I have a similar problem and i've actually tried your solution above
to no avail. May I email you my spreadsheet and the sample XML i'm
using? I'll really appreciate your help. I'd actually now resorted to
mapping each row (1199 rows) in excel to each element in the xml and
this is a painful task. I'll really appreciate your assistance in this
regard.

Thanks in advance.
Simon

 

[Shane]

Oh my goodness. Thank you for taking the time to answer your own question. I've been trying to figure this out for about four hours. Your solution worked fine for me. Life-saver, thanks!!