Showing posts with label How to read German characters in Excel via PHPExcel. Show all posts
Showing posts with label How to read German characters in Excel via PHPExcel. Show all posts

Sunday, 11 August 2013

How to read German characters (äöü߀) in Excel via PHPExcel

- Using PHPExcel we can create excel in php.
- In that excel creation german characters not displayed when given that words directly like " Jörg Blümel "

- For that we need to use,

 - PHPExcel uses UTF-8 internally, so it will render all characters correctly if your html page is set as UTF-8
$value = "Jörg Blümel";
$newValue = iconv("ISO-8859-1", "UTF-8", $value);