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