export excell data as xml
I trying to export an excell datasheet as xml using the sava as "xml data"
function
I got an error that my schema is not goot for saving the data
can some one give me a working scema example.
this is what I tried:
<?xml version="1.0"?
<xs:schema id="AAA" targetNamespace="http://tempuri.org/csdfsdfs1.xsd"
xmlns:mstns="http://tempuri.org/csdfsdfs1.xsd"
xmlns="http://tempuri.org/csdfsdfs1.xsd"
xmlns:xs="http://www.w3.org/2001/XMLSchema"
xmlns:msdata="urn:schemas-microsoft-com:xml-msdata"
<xs:element name="AAA" msdata:Locale="he-IL"
<xs:complexType
<xs:choice maxOccurs="unbounded"
<xs:element name="BBB"
<xs:complexType
<xs:sequence
<xs:element name="CC" type="xs:string" /
<xs:element name="DD" type="xs:string" /
</xs:sequence
</xs:complexType
</xs:element
</xs:choice
</xs:complexType
</xs:element
</xs:schema
|