ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   export excell data as xml (https://www.excelbanter.com/excel-worksheet-functions/31850-export-excell-data-xml.html)

moital

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


All times are GMT +1. The time now is 01:20 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com