Spreadsheet::ParseExcel non-english characters

Posted on 2008-07-23 20:06:45-07 by stevenshen

when I used Spreadsheet-ParseExcel to convert a excel file to TXT file, I got problem. If the value has some non-english characters (non-ascii characters), some of the values (whole cell value and include English characters) will not be found in the txt file after converted. Can you help me for the issue? I will really appreciate if you can help me. Thank you.

Direct Responses: 8411 | Write a response

Posted on 2008-07-26 10:36:52-07 by maehrus in response to 8389

Re: Spreadsheet::ParseExcel non-english characters

Do you mean that the whole cell content ist missing in your text-file, or just those non-ascii chars? I never had a problem like this, but I remember I checked the cell-object for Unicode, for example. Do you have a sample-file, maybe, just for testing? It also would be nice to know your OS.

Direct Responses: 8491 | Write a response

Posted on 2008-08-04 12:28:53-07 by stevenshen in response to 8411

Re: Spreadsheet::ParseExcel non-english characters

Dear maehrus, I really appreciate your response. The problem is that the Whole cell content is missing in my test file if there are some non-english characters in the cell. The CPAN do not allow me to paste the sample cell values with the non-english characters. Can I email the xls file as a sample to you? my email address is stevenshen66@yahoo.com. My OS is 'SunOS hera 5.8 Generic_117350-22 sun4u sparc SUNW,Sun-Fire-880' Thank you so much for help. Steven Shen

Direct Responses: Write a response

Perl Weekly newsletter
A free weekly newsletter for people who are busy to read all the blogs. click here to check it out.