Excel Encoding

M

Mark Fox

Hello

This may or may not be the correct newsgroup to post in for this, I have a question about the way Excel handles encoding. I have an ASP.NET application that exports to Excel by exporting an HTML table with an ".xls" extension. Excel reads the table without a problem, but I am having trouble with the encoding of the text in the table. Some of the tables include Hebrew and are sent as Unicode. When I export these tables sometimes they open correctly in Excel and sometimes the Hebrew is displayed as garbage. When the export works correctly, Excel is reading the XLS as Unicode UTF-8 (under Tools-Options-General-Web Options-Encoding) and when the export doesn't work Excel is reading it as Western European (Windows). When I manually change the encoding from Western European to UTF-8 (under "Reload this document as") for exports that don't work, it reloads it and correctly displays the Hebrew. My question is this: How do I manually tell Excel to open a document using UTF-8 encoding from within the document? Any help would be appreciated. Thanks

Please also note that I have opened exports that work and ones that don't in Notepad and both display the Hebrew correctly in the text editor
 
P

Peter Huang

Hi,

Based on my test, it seems that the encoding option will be available when
excel read a webpage.

And we can define a webpage's coding by using the charset in the http
header.
<head>
<meta http-equiv=Content-Type content="text/html; charset=utf-8">
</head>

So you may try to add the the meta property to the file generated by the
asp.net application to see if the works for you.


Best regards,

Peter Huang
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.
 
P

Peter Huang

Hi,

Have you tried my suggestion that indicates the charset in the header of
the html file?
If you still have any concern on this issue, please feel free to post here
and I will work on you with it.

Best regards,

Peter Huang
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.
 
M

mauricio.uchimura

I have a similar problem with a csv file. After download a csv file when I try to open with excel 2000 some UTF-8 characters are showed incorrectly. Is there any configuracion in excel to support UTF-8 encoding ? Same question for ms projec
If I open the file with MS word characters are displayed correctly after select UTF-8 encoding

Regard
M


----- "Peter Huang" wrote: ----

Hi

Have you tried my suggestion that indicates the charset in the header of
the html file
If you still have any concern on this issue, please feel free to post here
and I will work on you with it

Best regards

Peter Huan
Microsoft Online Partner Suppor

Get Secure! - www.microsoft.com/securit
This posting is provided "AS IS" with no warranties, and confers no rights
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Convert UTF-16 Unicode to UTF-8 Unicode? 1
Setting column width in a table with a macro is not working 0
Dates In Excel 5
Save as word to xml is splitting place holders ex: $abc.xyz$ 0
open UTF8 CSV 0
Embed the same Excel multiple times 0
Excel freezing after sharing document by Email 0
Images are pixelated when saving to PDF 0

Top