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

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.

Comment on Re^3: Spreadsheet::WriteExcel with UTF-8 text Download Code

Replies are listed 'Best First'.
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]