xls Schema troubles

[bob808a]

I am trying to export some data to xml, for use in a cs5 flash application. The data contains German characters (öäüß) and as such the "standalone" attribute MUST be set to "no" (or not be present) - other wise the characters won't appear, or will come up like "u%1/4" etc

The problem is that the output file keeps coming up with; standalone="yes" any ideas why?? At first I didn't specify the attribute and excel put it in by itself and now I have specified it to be "no" and it still generates a yes in the xml that is out putted.

Here is my xls:

<?xml version="1.0" encoding="UTF-8" standalone="no" ?>
<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema">
<xs:element name="AngebotslisteTable">
<xs:complexType>
<xs:sequence>
<xs:element ref="AngebotslisteRow" minOccurs="0" maxOccurs="unbounded"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="AngebotslisteRow">
<xs:complexType>
<xs:sequence>
<xs:element name="Kunde" type="xs:string"/>
<xs:element name="Projektbezeichnung" type="xs:string"/>
<xs:element name="bearbeitende" type="xs:string"/>
<xs:element name="Pate" type="xs:string"/>
<xs:element name="Datum" type="xs:date"/>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:schema>

[Steffen Thomsen]

What about enclosing the actual data in CDATA tags, this way it wont be parsed by the parser?

[bob808a]

How do I do that?

[Steffen Thomsen]

Read this article:

http://www.w3schools.com/xml/xml_cdata.asp

[bob808a]

Thanks for the response, but I can't get it to work. If I put cdata in the schema file it either makes it unreadable to excel, or it just skips the "standalone" attribute completely giving me the same issue.

I can't put the cdata in the xml file because it is being overwritten entirely, so that has no effect.

And I have no idea how to write something in vb so again a wall.

Where could I put cdata so that it may have the desired effect, or failing that, how do I create a xml using vb, so that I can define the "standalone" attribute there?

Thanks again.
Bob

[bob808a]

OK I have figured out the issue, and this is now irrelevant.
thanks for your help.