LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
whk
 
Posts: n/a
Default How to map multiple occurences of xml element in a sequence to Exc

I'm trying to map a single XML element to multiple columns in a list in Excel
and I'm having a bit of trouble.

The relevant part of my mapped schema:
<xs:complexType name="conflictType"
<xs:attribute name="id" type="xs:string" use="required"/
<xs:sequence
<xs:element ref="name"/
<xs:element ref="description"/
<xs:element name="entity" type="entityType" minOccurs="2" maxOccurs="2"/
</xs:sequence
</xs:complexType
<xs:complexType name="entityType"
<xs:attribute name="id" type="xs:int" use="required"/
<xs:attribute name="refid" type="xs:string" use="required"/
</xs:complexType

The sequence shows up as a list but the entity element which has a minOccurs
of 2 only appears once in the list. Is there a way to have it appear twice?

Thanks,

Ken
 
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
Move multiple rows of data that are not sequential Mel Excel Discussion (Misc queries) 1 January 20th 06 06:33 AM
lookup multiple values njclay Excel Worksheet Functions 3 January 16th 06 09:58 PM
AHHHH-Get Data from Multiple Excel workbooks JAA149 Excel Discussion (Misc queries) 5 October 30th 05 05:19 PM
How do I map multiple XML elements in excel? AStarWithin Excel Discussion (Misc queries) 1 May 3rd 05 01:46 PM
Mapping an XML element more than once?? AStarWithin Excel Discussion (Misc queries) 1 May 3rd 05 12:39 PM


All times are GMT +1. The time now is 01:12 PM.

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"