HighTechTalks DotNet Forums  

Unicode CSV files

Dotnet Internationalization microsoft.public.dotnet.internationalization


Discuss Unicode CSV files in the Dotnet Internationalization forum.



Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old   
John Clennett
 
Posts: n/a

Default Unicode CSV files - 08-29-2006 , 07:05 AM






I've posted this in the Excel forum but thought someone here may be able to
help.
I need to write unicode csv files from a dotnet application to be opened in
Excel.
I can write the files OK by setting
Response.ContentEncoding = System.Text.Encoding.Unicode
but when I try & open them in Excel it says 'The file is not in a
recognizable format'.
I haven't been able to see any settings to change the acceptable formats.
Anyone any ideas as to how this can be done?

Thanks,

John

Reply With Quote
  #2  
Old   
Mihai N.
 
Posts: n/a

Default Re: Unicode CSV files - 08-30-2006 , 12:47 AM






Quote:
I've posted this in the Excel forum but thought someone here may be able to
help.
I need to write unicode csv files from a dotnet application to be opened in
Excel.
I can write the files OK by setting
Response.ContentEncoding = System.Text.Encoding.Unicode
but when I try & open them in Excel it says 'The file is not in a
recognizable format'.
I haven't been able to see any settings to change the acceptable formats.
Anyone any ideas as to how this can be done?
Excel has internationalization problems with CSV that go beyond encoding.
See here: http://blogs.msdn.com/michkap/archiv...17/470413.aspx
It would be safer to try some other format (for instgance xml)


--
Mihai Nita [Microsoft MVP, Windows - SDK]
http://www.mihai-nita.net
------------------------------------------
Replace _year_ with _ to get the real email


Reply With Quote
Reply




Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.4
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.