newbie question how to write french éèçà in sheets

Topics: User Forum
Oct 25, 2012 at 12:57 PM
Edited Oct 25, 2012 at 1:11 PM

Hi everybody,

I have read the documentation, I made some xlsx sheets but I do not manage to write word such as "Dépenses" (expenses)  in a setCellValue. It leads to just "D" in the excel cell.

I tried "De&acutepenses" but it does not work. Is there something to add into the header() command ?

I also tried to add

header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet; charset=iso-8859-1');

before calling the createWriter function. It does not work either.


Oct 25, 2012 at 4:35 PM

OK, I found how to get the accents. Just do a setCellvalue('A1',utf8_encode('évident!')); If this helps any frenchy around....