Re^4: Handling variety of languages/Unicode characters with Spreadsheet::ParseExcel

Thanks for your reply. I think your comments summarize the situation/problem nicely.

Frankly, the source spreadsheet is a mess! :)

I like your approach of segregating the non-Latin data separately and using Encode::Guess. I will experiment with that and see if I can make things better.

In the meanwhile, I'll have to tell the folks creating these spreadsheets to not do what was done here.

Thanks again for your help!

Comment on Re^4: Handling variety of languages/Unicode characters with Spreadsheet::ParseExcel

Replies are listed 'Best First'.
Re^5: Handling variety of languages/Unicode characters with Spreadsheet::ParseExcel by mjoinsd (Initiate) on Jul 14, 2010 at 21:58 UTC
Did you find a solution yet? I have a spreadsheet that contains English and Chinese which I am trying to import into MySQL as appropriate. It also has a column of MS specialized characters (= < >) which is also driving me nuts. I'm getting nowhere with all the suggestions on this posting. I'm not exactly a noob with Perl, but have never worked with internationalization and encoding.	[reply]