Exporting XML data

[Ioannis]

When I export XML data, a message tells me that the XML maps in my workbook are not export.
I know that an XML mapping cannot be exported if the mapped element’s relationship with other elements cannot be preserved. This relationship may not be preserved for the following reasons:
The schema definition of a mapped element is contained within a sequence with the following attributes:
The maxoccurs attribute is not equal to 1.

Why is that? I don't understand.
Moreover, how could i have repeated elements without the maxoccurs>1 ???


For example, i have the following schema (from http://office.microsoft.com/en-us/ex...1041933.aspx):

<?xml version="1.0" encoding="UTF-8" standalone="no" ?>
<xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<xsd:element name="Root">
<xsd:complexType>
<xsd:sequence>
<xsd:element minOccurs="0" maxOccurs="1" name="EmployeeInfo">
<xsd:complexType>
<xsd:all>
<xsd:element minOccurs="0" maxOccurs="1" name="Name" />
<xsd:element minOccurs="0" maxOccurs="1" name="Date" />
<xsd:element minOccurs="0" maxOccurs="1" name="Code" />
</xsd:all>
</xsd:complexType>
</xsd:element>
<xsd:element minOccurs="0" maxOccurs="unbounded" name="ExpenseItem">
<xsd:complexType>
<xsd:sequence>
<xsd:element name="Date" type="xsd:date"/>
<xsd:element name="Description" type="xsd:string"/>
<xsd:element name="Amount" type="xsd:decimal" />
</xsd:sequence>
</xsd:complexType>
</xsd:element>
</xsd:sequence>
</xsd:complexType>
</xsd:element>
</xsd:schema>

This example cannot be exported.

[garuru]

Excel just doesn't support this....

see these references:
http://office.microsoft.com/en-us/ex...115.aspx?CTT=3

http://office.microsoft.com/en-us/ex...010206401.aspx

trying to think of a work around. please post here if anyone has ideas. I am assuming we are here because we want to be able to use Excel to make updates to xml data to be consumed by other tools.