Encoding, charset or whatever

Question

User-542489397 posted
Hello,
I used technique showed here: http://support.microsoft.com/kb/317719/ to export data to Excel using mime-types. Since my language is not English, my letters are not shown correctly in Excel. Can you please help me to find out how to solve this?

Thanks

Answer 1

User-403641541 posted

Hello,
I used technique showed here: http://support.microsoft.com/kb/317719/ to export data to Excel using mime-types. Since my language is not English, my letters are not shown correctly in Excel. Can you please help me to find out how to solve this?

Thanks

 

see this line:

Response.Charset = ""

 

provide a charset value instead of leaving it blank.

Answer 2

User1416329745 posted

Hello,
I used technique showed here: http://support.microsoft.com/kb/317719/ to export data to Excel using mime-types. Since my language is not English, my letters are not shown correctly in Excel. Can you please help me to find out how to solve this?

Thanks

Yes I can Excel is the strange animal that uses UTF7 so change that line.  Hope this helps.

Response.Charset = ""   to  Response.ContentEncoding = System.Text.Encoding.UTF7

Answer 3

User-542489397 posted
Your response helped me. Thank you. I would never guess [:)]

Answer 4

User1416329745 posted

Your response helped me. Thank you. I would never guess [:)]

I glad I could help you are not the first, a while back I gave it to someone who did not change it for two days before doing it,  he wanted to know what UTF7 had to do with it? I just said Microsoft Excel is proprietry so maybe UTF7 worked all the time and UTF8 does not.