We have written a web application for Korean Users in ASP.NET1.1 and we are displaying the Web site text in Korean. We have some reports where we export the data to .csv files and our problem is that if we use Response.ContentEncoding = Unicode than ','
is not treated as ',' and all the values are pushed to one column while opening in Excel.
I tried with other code pages and charsets but nothing worked till now. Can we use any other encoding than Unicode to handle this?
None
0 Points
1 Post
Exporting Korean text to .CSV FIle
Jun 28, 2006 01:16 AM|rasraj|LINK
Hi,
We have written a web application for Korean Users in ASP.NET1.1 and we are displaying the Web site text in Korean. We have some reports where we export the data to .csv files and our problem is that if we use Response.ContentEncoding = Unicode than ',' is not treated as ',' and all the values are pushed to one column while opening in Excel.
I tried with other code pages and charsets but nothing worked till now. Can we use any other encoding than Unicode to handle this?
Any inputs are welcome. Thanks in advance.
Regards,
Rasraj
Contributor
4150 Points
5249 Posts
Re: Exporting Korean text to .CSV FIle
Jun 28, 2006 09:31 AM|Caddre|LINK
Excel uses UTF-7 try the thread below to fix your problem. Hope this helps.
http://forums.asp.net/ShowThread.aspx?PostID=924671#925150