in reply to Re^2: What to do when converting Excel-supplied data to Unicode
in thread What to do when converting Excel-supplied data to Unicode
I'd be interested to know if my specific solution makes the "special case" code unnecessary. IIRC, the data that is outside of ISO-8859-1 is encoded by Excel as UTF-16 (Big Endian I think) which would mean that everything would be valid UTF-8 data coming out -- without having to hardcode a list of search-and-replace operations for specific characters.
P.S. - By the way, my specific experience was with Excel 2003. I'm guessing older versions of the file format may have handled things differently.