Convert special characters to xml

[seeyou]

Hi.

I am trying to create an ExcelXP worksheet file, in a xml format.
All it seems ok, but if i use special characters, it will be replaced by another characters.

This is an example of a problematic string:
&quot;<Cell><Data ss:Type=&quot;String&quot;>Olá. É só para dizer que não sou de Guimarães</Data></Cell>&quot;

How is the best (fast) way to solve this problem?
Note: In spite of my sample has a little string, I need to replace the special chars on a quite large table, so I can't replace chars one by one (performance is very important). --- seeyou ---

 

[JOLESEN]

The XML can easily handle characters like that, since it can be stored ad UTF8 / Unicode.
How (which tools) do you use to create the file ?
/JOlesen

 

[adrianf]

In my experience manually &quot;replacing&quot; characters has caused more problems tha it has solved. We NEVER manually code XML strings. Instead we always use the MS Parser objects to build the node sets, which takes care of any character substitutions for you so you can concentrate on the rest of your application.

 

[JOLESEN]

Adrianf : Agree !!
/JOlesen

 

[chiph]

seeyou -

Forming XML via string concatenation causes problems like this. Do like the others have said, and use the Node and Element objects to populate your XML document.

Chip H.

 

[seeyou]

Ok.

Thanks for helping me.
I solved my problem with the XmlTextWriter and the WriteRaw clause.
Now, all it´s perfect.
--- seeyou ---