export excell data as xml

M

moital

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>
 

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