W
wembley
I am looking to find out if one can use XML Maps to map to a complex
structure that spans X number of rows and repeats downward Y number of times.
I have seen XML Maps used with purely tabular data where a row corresponds
to a single entry within a list in an XML document.
For my case, a single XML list "entry" corresponds to multiple rows
(spanning 20 rows) and covers multiple columns (A-G). This range represents
one complex entry in the XML document. The next entry starts at row 21 and
goes up to and including row 40. The next 41 through 60 and so on.
I know the XML document can handle this content but how would I use XML Maps
to, say map to the first complex data entry in rows 1 through 20, and then
indicate to Excel to repeat this XML mapping going down the worksheet until
the used range has been exhausted?
Can this be done? Any help would be greatly appreciated.
Thanks,
structure that spans X number of rows and repeats downward Y number of times.
I have seen XML Maps used with purely tabular data where a row corresponds
to a single entry within a list in an XML document.
For my case, a single XML list "entry" corresponds to multiple rows
(spanning 20 rows) and covers multiple columns (A-G). This range represents
one complex entry in the XML document. The next entry starts at row 21 and
goes up to and including row 40. The next 41 through 60 and so on.
I know the XML document can handle this content but how would I use XML Maps
to, say map to the first complex data entry in rows 1 through 20, and then
indicate to Excel to repeat this XML mapping going down the worksheet until
the used range has been exhausted?
Can this be done? Any help would be greatly appreciated.
Thanks,