View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ollie[_4_] Ollie[_4_] is offline
external usenet poster
 
Posts: 1
Default Codepages and displaying euro sign

We are outputting a CSV file from a .Net (C#) application and it is writing
the euro currency sign (‚¬), we are using the default encoding for the
StreamWriter class which is UTF-8 (65001).

When the file is viewed in notepad, it displays the character correctly but
in MS Excel 2003 (XP SP2) the character is translated to '‚¬'.. We can
resolve the issue by specifiying the windows 1252 codpage when generating the
file, but we are wondering if this is the correct approach or it there a more
suitable solution?

Also what is the codepage used for MS Excel 2003? - is this dependant on the
OS Locale at all.

Cheers

Ollie Riches