How to map multiple occurences of xml element in a sequence to Exc

W

whk

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top