Excel export encoding problem ( big tip )
Category: Computers > Software
Asked by: modjoe23-ga
List Price: $10.00
13 Nov 2006 20:13 PST
Expires: 13 Dec 2006 20:13 PST
Question ID: 782546
I am trying to figure out how to fix my problem when exporting from my C# asp.net application to excel. The problem I am facing is that I need my character set to be UTF-8 compliant and it seems that Excel will open the default codepage when it opens the report so it will not recognize some characters ( Korean ) for example and will replace them with question marks. I know that using JET OLE is one of the ways to go to fix this. If you tell me that it is not and support it I will definitely put in a bonus tip. Otherwise, what I am looking for is what are the possible solutions. A detailed explanation will also get a much bigger tip. I know this can be done precisely because Google Adwords does it when generating excel reports. Note: Setting charset = "utf-8" and .encoding = System.text.utf8 ( or something of the sort ) does NOT work. Thanks.
|There is no answer at this time.|
Re: Excel export encoding problem ( big tip )
From: pooranprasad-ga on 29 Nov 2006 12:03 PST
1. You can try writing this before rendering the excel Response.ContentType = "application/vnd.ms-excel" Response.AddHeader "Content-Disposition", "inline; filename=a.xls" 2. If it does not, check if these solve your issue http://support.microsoft.com/kb/307029 and http://support.microsoft.com/kb/306023
If you feel that you have found inappropriate content, please let us know by emailing us at email@example.com with the question ID listed above. Thank you.
|Search Google Answers for|