locked
Encoding, charset or whatever RRS feed

  • 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
    Tuesday, October 10, 2006 7:17 AM

Answers

  • 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

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Tuesday, October 10, 2006 9:06 AM

All replies

  • 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.

    Tuesday, October 10, 2006 7:35 AM
  • 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

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Tuesday, October 10, 2006 9:06 AM
  • User-542489397 posted
    Your response helped me. Thank you. I would never guess [:)]
    Tuesday, October 10, 2006 11:49 AM
  • 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.

    Tuesday, October 10, 2006 1:54 PM