Hi Marc, in the character range 0-31 only 9, 10 and 13 are legal (see http://www.w3.org/TR/REC-xml/#charsets). You cannot encode the other characters in XML. Regarding the leading zero I can´t find anything in the specification (See http://www.w3.org/TR/REC-xml/#NT-CharRef) that would indicate that you have to do that. Are you sure that MS-Excel accepts illegal XML characters if they are encoded in decimal form with a leading zero? If yes, then that is a non standard extension (or bug?) and perhaps the quoting in SXSSF should be changed to support that. Regards, Alex
-- View this message in context: http://apache-poi.1045710.n5.nabble.com/Creating-XML-Safe-XLSX-Files-via-the-streaming-API-tp4900642p4904910.html Sent from the POI - User mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
