homepage Welcome to WebmasterWorld Guest from 54.205.188.59
register, free tools, login, search, subscribe, help, library, announcements, recent posts, open posts,
Subscribe to WebmasterWorld

Home / Forums Index / Code, Content, and Presentation / XML Development
Forum Library, Charter, Moderators: httpwebwitch

XML Development Forum

    
Excel doesn't like accent characters
cantona




msg:3848100
 4:52 pm on Feb 12, 2009 (gmt 0)

Hi

I'm downloading data from my utf-8 db, putting it in XML tags (via PHP) and then downloading it as either CSV, HTML or XML.

Opening HTML and XML in my browser or editplus (simple text program) works fine and the french accent characters display properly.

But if I download as a CSV and open in Excel, the accent characters break.

Even if I open the HTML file (which works in the browser) in Excel, the accent characters break.

For the HTML file, I'm specifying utf-8 as so....


Content-Type: text/html; charset=UTF-8

Any ideas why MS Excel would ignore the specified charset when opening a file?
When I import the file I'm able to specify 'Unicode (UTF-8)' and that works.

Also, when downloading as CSV, do I also have to specify charset?

Content-Type: text/csv; charset=UTF-8

Thanks!

 

httpwebwitch




msg:3873313
 3:25 pm on Mar 18, 2009 (gmt 0)

bump

cantona, did you find a solution for this?

choster




msg:3873476
 5:19 pm on Mar 18, 2009 (gmt 0)

FWIW, I have never coaxed Excel into handling encoding properly (it also has a problem with handling quoting in CSV files). While I prefer Excel for "real" spreadsheet work, OpenOffice Calc is fine for making simple text changes.

cantona




msg:3874025
 8:14 am on Mar 19, 2009 (gmt 0)

Work around:

I read somewhere that MS Office doesn't yet fully support UTF-8 characters.

So if the download format specified was *SV or RTF then I changed the character set back to latin1 using utf8_decode()

We no longer have accent problems in Excel.

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Code, Content, and Presentation / XML Development
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved