Converting XML to Excel

[Guest_imported]

I’m converting an XML document to Excel 97 format through VBA. I’m assigning text values to cells by using the selectSingleNode.Text property. Here’s the problem: as soon as there’s an international character (example: eacute), the text string gets truncated at that position. My DTD already handles these as entities under ISO-8859-1 encoding. The XML document loads without any errors, and if I view it through Internet Explorer, all of the text shows. Does anyone have any ideas of what I could be overlooking?

 

[flumpy]

I take it you are using & # x115; as the e accute character in your dtd? Try changing encoding to UTF-8, see if it makes a difference. Its only a guess but Excel may try to read the international character as an eol (or something) when encoded in ISO standard, so changing to UTF-8 might just help.

Another option is to place a '\' in front of the character in the xml definition. Sounds crazy i know, but excel seems to understand the literal character indicator "\".

If that doesnt work, I'm afraid I cant help you

good luck

 

[Guest_imported]

Thanks, Flumpy. I'll give it a whirl.