R
Roberto
Hi,
When I import an xml doc into excel 2007 all the nodes are arranged on one
row. I would like for each subnode to be inserted on a new row. My simple xml
doc reads as follows:
<?xml version="1.0" encoding="utf-8" ?>
<root>
<aaaa>
<english>
something in english
</english>
<swedish>
something in swedish
</swedish>
</aaaa>
<bbbb>
<english>
something in english
</english>
<swedish>
something in swedish
</swedish>
</bbbb>
</root>
Importing above xml results in:
something in english something in swedish something in english something in
swedish
when I would like it to result like this:
something in english something in swedish
something in english something in swedish
Never used excel before and would be greatful for any help on this.
When I import an xml doc into excel 2007 all the nodes are arranged on one
row. I would like for each subnode to be inserted on a new row. My simple xml
doc reads as follows:
<?xml version="1.0" encoding="utf-8" ?>
<root>
<aaaa>
<english>
something in english
</english>
<swedish>
something in swedish
</swedish>
</aaaa>
<bbbb>
<english>
something in english
</english>
<swedish>
something in swedish
</swedish>
</bbbb>
</root>
Importing above xml results in:
something in english something in swedish something in english something in
swedish
when I would like it to result like this:
something in english something in swedish
something in english something in swedish
Never used excel before and would be greatful for any help on this.