Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
topographical data maps in excel | Charts and Charting in Excel | |||
Persistent Data Structures in VBA | Excel Programming | |||
data structures | Excel Programming | |||
how can i produce regional maps with demographic data using excel. | Charts and Charting in Excel | |||
Country data maps | Excel Discussion (Misc queries) |