PHP: UTF-8 and Spreadsheet Excel Writer

Posted on April 8th, 2008 by Florian

Spreadsheet Excel Writer is a handy tool to generate MS Excel files with php. But it has some trouble handling utf-8 sources. Luckily Research e-Labs describes a simple solution:

After recently working on an application to generate Microsoft Excel documents using a PHP script, I ran into trouble with the PEAR package “Spreadsheet Excel Writer” which didn’t correctly display UTF-8 characters (Māori macrons in this case). Here is a fix!

Categories: Development //

2 Responses to “PHP: UTF-8 and Spreadsheet Excel Writer”

  1. iivs // Jun 30, 2008 at 4:42 pm

    Thank you so much, this was a great help.

  2. Dan // Jul 23, 2009 at 4:47 pm

    mb_convert_encoding($value, “UTF-8″,”ISO-8859-1″);
    worked for me

Leave a comment if you like:




« Google Static Maps Finding color schemes with Adobe Kuler »