How to map lists of list from a xml file in Excel 2003
Here a sample of my xml file:
Code Snippet
<root>
<group>
<item>
<item>
</group>
<group>
<item>
<item>
</group>
</root>
That's a list of groups inside a list of items. We can map the items with cells in excel but not the groups (because there's already a list of tags inside this list)
Is it possible to write a macro with which we could define that:
for example in column C
- rows 2 to 3, the two rows are mapped with the two items of the first group
- rows 5 to 6, the two rows are mapped with the two items of the second group
- etc
Many thanks for your help!
Mathmax
[1175 byte] By [mathmax] at [2008-1-8] 