xmlDocument.Sav e "
" getting changed changed to "&#10"

[st]

Hi,

I'm using xmlDocument.Sav e(xmlTextWriter ) to create an Excel-readable
file. All works well, except where I've replaced the carriage return
chars in the .innertext to XML-compliant "&#10"; It gets changed to
"&#10" and doesn't render new lines in the Excel sheet.

Can anyone help?

Many thanks,

Simon Lane

[Pascal Schmitt]

Hello!

I'm using xmlDocument.Sav e(xmlTextWriter ) to create an Excel-readable
file. All works well, except where I've replaced the carriage return
chars in the .innertext to XML-compliant "&#10"; It gets changed to
"&#10" and doesn't render new lines in the Excel sheet.

Don't use any strings with entities in any of the XML-classes - all
strings will be "XML-encoded" when saving.

Try the XmlTextWriter.W riteCharEntity-Method:
<http://msdn2.microsoft .com/en-us/library/2kd5s00k>

I don't know if whitespace characters are an exception, but you usually
don't have to care about Entities, just use the .NET Unicode-strings,
they will be converted into the right entites when writing the XML.
(You see, your "&#x10;" becomes "&amp;#x10; ", "2>5" becomes "2&lt;5"... )
--
Pascal Schmitt