From: Wayne Brisette Date: 2013-02-06T04:03:20+09:00 Subject: Re: Ruby could recognize the values when putting into a webpage text filed. > But in excel column those values are quite OK,only the problem is when > program reading the excel column by the above program, something wrong > happened. definitely it is encoding problem. So in my code doing some > change- can you guide me? Do you ever read ANY of the links people provide? I'm sure I'm not the only one, but why is it you seem to want people to spoon feed you everything? You're right, you have an encoding issue. You have some sample Excel data that comes into Ruby incorrectly, so now try stuff! Go read the encoding links provided, you'll find there's a very elegant way in Ruby to take the existing encoding and change it. Run a few tests. Reencode the incoming string with multiple encoding methods. Look at the output, When you see the one that fixes your issue you'll know exactly what to do. Wayne