ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How to map multiple occurences of xml element in a sequence to Exc (https://www.excelbanter.com/excel-discussion-misc-queries/67909-how-map-multiple-occurences-xml-element-sequence-exc.html)

whk

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


All times are GMT +1. The time now is 01:49 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com