Excel -> XML issue with special characters

[dbleyl]

How do you get Excel data w/ special characters, like +/- degree, or foreign characters w/ accents to convert to valid UTF-8 encoded data?

I'm using JDom + POI to create an XML file from an Excel spreadsheet. The xsl renders an HTML file where the symbols are legible, but not encoded properly.

The xml file in IE generates either ? for the character or

"An Invalid character was found in text content."


Thanks in advance.

 

[dbleyl]

Ok, problem was encoding during the creation of the XML file, xsl encoding and <xslutput encoding&quot;...

Once everything uses ISO-8859-1 everyone is happy. (Of course this won't work for non-ISO-8859-1 characters inserted into excel files through Character Map or whatnot).