Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Convert special characters to xml

Status
Not open for further replies.

seeyou

Programmer
Oct 11, 2002
12
PT
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 ---
 
Ok.

I solved my problem with the XmlTextWriter and the WriteRaw clause.
Now, all it´s perfect.

--- seeyou ---
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top