How to encode unicode in XLSX sheet ? [Resolved]

Posted by Sahoo under ASP.NET on 7/29/2013 | Points: 10 | Views : 1301 | Status : [Member] | Replies : 2
Hi

I have an application that generate xls sheet .But it is unable to render unocode character like Russian,Chinese correctly.
How to set encoding here ?
Is dere any other way to handle it .


Thanks




Responses

Posted by: aswinialuri-19361 on: 7/29/2013 [Member] Starter | Points: 50

Up
0
Down

Resolved
hi,
Refer this link it might be helpful to you
http://blogs.msdn.com/b/saurabh_singh/archive/2008/02/27/unable-to-correctly-display-chinese-unicode-characters-in-excel-when-opened-through-asp-net-page.aspx

http://stackoverflow.com/questions/1679656/asp-net-excel-export-encoding-problem


Ihope you understand after trying this link

Mark as Answer if it helps you
Thanks&Regards
Aswini Aluri

Sahoo, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Kmandapalli on: 7/29/2013 [Member] Silver | Points: 25

Up
0
Down
Hi,

You have an encoding problem. When you use Unicode literals in your source code, you must use the utf8 pragma and save your program source code encoded as UTF-8.

For more reference you can go through the following links:

https://xlsxwriter.readthedocs.org/en/latest/example_unicode_polish_utf8.html

Mark as answer if satisfied.....

Regards,
Shree M.

Kavya Shree Mandapalli

Sahoo, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response