XML map in excel

[wlehane]

Hi, I'm trying to import an xml map into excel, I imported it in sucessfully initally but then it would not let me export because of list of lists. Now i have removed the list of lists from the schema but now the map isn't importing into excel properly, here is the schema.

Can anyone help please

<?xml version="1.0" encoding="UTF-8" ?>
- <!--
Document History:
Created 17/06/2003
Current Version: v1

-->
- <xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns="http://www.ros.ie/schemas/intrastat/v1/" xmlns:ros="http://www.ros.ie/schemas/rostypes/" targetNamespace="http://www.ros.ie/schemas/intrastat/v1/" elementFormDefault="qualified" attributeFormDefault="unqualified">
- <xsd:element name="Istat">
- <xsd:complexType>
<xsd:attribute name="formversion" type="xsd:string" use="required" fixed="1" />
<xsd:attribute name="periodstart" type="xsd:date" use="required" />
<xsd:attribute name="periodend" type="xsd:date" use="required" />
<xsd:attribute name="language" type="xsd:language" use="required" />
- <xsd:attribute name="returnType" use="required">
- <xsd:simpleType>
- <xsd:restriction base="xsd:integer">
<xsd:enumeration value="0" />
<xsd:enumeration value="1" />
</xsd:restriction>
</xsd:simpleType>
</xsd:attribute>
- <xsd:attribute name="flow" use="required">
- <xsd:simpleType>
- <xsd:restriction base="xsd:string">
<xsd:enumeration value="A" />
<xsd:enumeration value="D" />
</xsd:restriction>
</xsd:simpleType>
</xsd:attribute>
<xsd:attribute name="statPeriod" type="xsd:date" use="required" />
- <xsd:attribute name="partyType" use="required">
- <xsd:simpleType>
- <xsd:restriction base="xsd:NMTOKEN">
<xsd:enumeration value="PSI" />
<xsd:enumeration value="TPD" />
</xsd:restriction>
</xsd:simpleType>
</xsd:attribute>
<xsd:attribute name="vatNum" type="xsd:string" use="required" />
<xsd:attribute name="name" type="xsd:string" use="required" />
<xsd:attribute name="address1" type="xsd:string" use="required" />
<xsd:attribute name="address2" type="xsd:string" use="required" />
<xsd:attribute name="address3" type="xsd:string" use="optional" />
<xsd:attribute name="contact" type="xsd:string" use="required" />
<xsd:attribute name="phone" type="xsd:string" use="required" />
<xsd:attribute name="email" type="xsd:string" use="required" />
- <xsd:attribute name="arrivals" use="optional">
- <xsd:simpleType>
- <xsd:restriction base="xsd:integer">
<xsd:enumeration value="0" />
<xsd:enumeration value="1" />
</xsd:restriction>
</xsd:simpleType>
</xsd:attribute>
- <xsd:attribute name="dispatch" use="optional">
- <xsd:simpleType>
- <xsd:restriction base="xsd:integer">
<xsd:enumeration value="0" />
<xsd:enumeration value="1" />
</xsd:restriction>
</xsd:simpleType>
</xsd:attribute>
<xsd:attribute name="ctryConsignDestn" type="xsd:string" use="required" />
<xsd:attribute name="ctryOrigin" use="optional" />
- <xsd:attribute name="transaction" use="required">
- <xsd:simpleType>
- <xsd:restriction base="xsd:integer">
<xsd:pattern value="[1-9]" />
</xsd:restriction>
</xsd:simpleType>
</xsd:attribute>
- <xsd:attribute name="transport" use="optional">
- <xsd:simpleType>
- <xsd:restriction base="xsd:integer">
<xsd:pattern value="[{1-5}{7-9}]" />
</xsd:restriction>
</xsd:simpleType>
</xsd:attribute>
<xsd:attribute name="delivery" type="xsd:string" use="optional" />
<xsd:attribute name="code" type="xsd:string" use="required" />
<xsd:attribute name="netMass" type="xsd:integer" use="optional" />
- <xsd:attribute name="netMassOpt" use="required">
- <xsd:simpleType>
- <xsd:restriction base="xsd:string">
<xsd:enumeration value="O" />
<xsd:enumeration value="M" />
</xsd:restriction>
</xsd:simpleType>
</xsd:attribute>
<xsd:attribute name="suCode" type="xsd:string" use="required" />
<xsd:attribute name="suQuanity" type="xsd:integer" use="optional" />
<xsd:attribute name="invEuroValue" type="xsd:integer" use="required" />
<xsd:attribute name="statEuroValue" type="xsd:integer" use="optional" />
</xsd:complexType>
</xsd:element>
</xsd:schema>