LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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,
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
topographical data maps in excel bobatduke Charts and Charting in Excel 1 November 11th 08 06:54 AM
Persistent Data Structures in VBA [email protected] Excel Programming 5 September 10th 07 04:20 PM
data structures vivmaha Excel Programming 2 June 26th 07 10:18 PM
how can i produce regional maps with demographic data using excel. Pedro Charts and Charting in Excel 2 March 30th 05 01:50 PM
Country data maps Albert Excel Discussion (Misc queries) 0 February 24th 05 10:59 PM


All times are GMT +1. The time now is 08:55 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"