I've been searching the discussions for quite some time now and cannot find the solution to my problem.
I'm trying to add the euro sign € in front of my financial numbers.
I've read that this has something to do with the charset so I've forced my php page to UTF-8 with this code:
I tried different ways of adding the euro sign to my NumberFormat:
- $objPHPExcel->getActiveSheet()->getStyle('G14')->getNumberFormat()->setFormatCode("€ #,##0.00");
- $objPHPExcel->getActiveSheet()->getStyle('G14')->getNumberFormat()->setFormatCode("_€ #,##0.00");
When generating the sheet is says:
Notice: iconv_strlen(): Detected an illegal character in input string in /classes/PHPExcel/Shared/String.php on line 544
Can any of you explain to me how to set the euro sign in a proper way? And if this is the way to set UTF-8 in my PHP page?
Thanks in advanced!!