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
|