UTF-8中的某些数据（如“æ”）无法正确显示

Question

I'm using the PHP port of John McNamara's Spreadsheet::WriteExcel Perl package which can be found here.

It works great but I have some data that are in UTF-8 such as æ and it doesn't display correctly inside the resulting file.

Answer 1

Looks like using iconv fixes the problem.

$worksheet->write(0, 0, iconv("UTF-8", "ISO-8859-1//TRANSLIT", $str));