Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
moital
 
Posts: n/a
Default 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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can you Auto fill address in excell with a data base? bayou beot Excel Worksheet Functions 1 May 12th 05 09:21 AM
Export address list data in an Excel worksheet for importing into. ACR/HJG Excel Discussion (Misc queries) 1 April 15th 05 11:43 PM
Microsoft Excell does not format the data numbers right justified. kevin Excel Discussion (Misc queries) 1 March 28th 05 01:31 AM
How do I transfer data between Excell sheets? Grafur Excel Worksheet Functions 2 February 19th 05 03:08 AM
How can I export Excel data to Quicken? acfoxb Excel Discussion (Misc queries) 1 January 2nd 05 10:27 PM


All times are GMT +1. The time now is 04:42 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"