![]() |
XML Maps and List of Complex Data Structures
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, |
All times are GMT +1. The time now is 01:41 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com