Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Move multiple rows of data that are not sequential | Excel Discussion (Misc queries) | |||
lookup multiple values | Excel Worksheet Functions | |||
AHHHH-Get Data from Multiple Excel workbooks | Excel Discussion (Misc queries) | |||
How do I map multiple XML elements in excel? | Excel Discussion (Misc queries) | |||
Mapping an XML element more than once?? | Excel Discussion (Misc queries) |