Write special characters

Topics: User Forum
Nov 21, 2012 at 3:03 PM

Hi all,

I'm trying to write "séparation" (french word) in a cell in excell5 writer, but everytime the file is not accepted by excel.

I've already converted my file to UTF8 without BOM, but no luck...

Do you have an idea?

Thank you!

Nov 21, 2012 at 10:02 PM

UTF-8 is the only way to write non-ASCII charaters; but "séparation" doesn't even need that: look at cell A5 in the spreadsheet generated by 01simple.php in the /Tests directory

Nov 22, 2012 at 8:02 AM


Thank you for your answer.

I've found the origin of the problem, not the solution...

Adding special characters in "normal" cells is okay, but when I want to make a rich text, it doesn't work.

Here is my code :

$testrich = new PHPExcel_RichText();
$testrichbold = $testrich->createTextRun("séparation");
$testrichbold->getFont()-> setBold(true);

// Miscellaneous glyphs, UTF-8
            ->setCellValue('A4', 'Miscellaneous glyphs')
            ->setCellValue('A5', 'éàèùâêîôûëïüÿäöüç')
			->setCellValue('A8', $testrich);

Any idea?


Thanks a lot,

Nov 23, 2012 at 10:28 AM


rich text is giving a lot of problems with excel 5 writer.

I'm not sure it is special chars related.

I'm avoiding richtext for excel 5 writer,using it just for 2007 writer..