I can't set the sheet title with chinese word

Topics: Developer Forum, Project Management Forum, User Forum
Jan 21, 2009 at 7:33 AM


Both of  two command can't set the right chinese word to display.

what can I do ?

Thank you!
Jan 21, 2009 at 7:40 AM
  1. Did you remember to save your PHP script as UTF-8 ?
  2. Are you using PHPExcel_Writer_Excel2007 or PHPExcel_Writer_Excel5 ?
Jan 21, 2009 at 7:44 AM
yes I save PHP script as UTF-8

and I use PHPExcel_Writer_Excel5
Jan 21, 2009 at 7:45 AM
like this:
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
Jan 21, 2009 at 7:50 AM
We have still not written auto-detection function to check whether iconv / mbstring is enabled on server.

Until we get that fixed, to use special characters with Excel5, you need mbstring extension. Use phpinfo() to check if you have it.

This is the correct way (when script is saved in UTF-8):


Feb 13, 2009 at 7:28 AM
Update: PHPExcel_Writer_Excel5 should now be working also without the mbstring extension.