Re^2: Spreadsheet::WriteExcel with UTF-8 text

Thank you very much for your help. I believe I have identified the problem...not having much experience with Windows, I didn't consider the question of whether the Excel version would be able to display Japanese characters. As your example spreadsheet gives the same type of results as my spreadsheet, I think the problem lies with interpretation, not writing.

Once again, thank you.

Comment on Re^2: Spreadsheet::WriteExcel with UTF-8 text

Replies are listed 'Best First'.
Re^3: Spreadsheet::WriteExcel with UTF-8 text by jmcnamara (Monsignor) on Mar 03, 2005 at 11:20 UTC
Some versions of Excel aren't installed with Unicode fonts by default. If you have one installed but Excel isn't associating it with your strings you tell it to by adding something like this to your program: `... # Set a Unicode font. my $uni_font = $workbook->add_format(font => 'Arial Unicode MS'); $worksheet->write('A1', $utf8_str, $uni_font); ...` [download] -- John.	[reply] [d/l]
Re^4: Spreadsheet::WriteExcel with UTF-8 text by Anonymous Monk on Mar 03, 2005 at 11:42 UTC
This is several years old--Excel 2000 9.0.2720. I'd have to look it up specifically to see if it has support, but given the age, if I had to guess, I'd guess not. Thanks for the tip; I will try it if someone with a newer version of Excel reports the same problem.	[reply]
Re^5: Spreadsheet::WriteExcel with UTF-8 text by dragonchild (Archbishop) on Mar 03, 2005 at 13:27 UTC
If you cannot upgrade your version of Excel, OpenOffice is an excellent replacement. Being right, does not endow the right to be rude; politeness costs nothing. Being unknowing, is not the same as being stupid. Expressing a contrary opinion, whether to the individual or the group, is more often a sign of deeper thought than of cantankerous belligerence. Do not mistake your goals as the only goals; your opinion as the only opinion; your confidence as correctness. Saying you know better is not the same as explaining you know better.	[reply]