cannot create xlsx file if accented characters

Topics: Developer Forum, User Forum
Aug 20, 2007 at 8:31 PM
i was changing my pgm to use Excel2007_Writer and was reading user info from a MySQL DB
it choked (said spreadsheet had errors) - i tracked it down to a user that has french accented characters in some of the text fields
this was the 1st user with accented characters
do i have to do something special to handle accented characters?

mark
Coordinator
Aug 21, 2007 at 7:19 AM
Please see http://www.codeplex.com/PHPExcel/Wiki/View.aspx?title=FAQ&referringTitle=Home (in short: use iconv())
Aug 21, 2007 at 6:40 PM
i am not sure what code page to use??
why doesn't the default accept french characters?

mark
Coordinator
Aug 21, 2007 at 8:42 PM
UTF8 should do the trick...

Also, utf8_encode() is an option to use.