在 Excel 2010 中使用 ANSI 编码打开 Excel
我有 ANSI 编码的 excel 文件（它是在 Excel 97 中生成的），但现在我需要使用 Excel 2010 打开此文件，但打开 ANSI 编码似乎有问题，因为我看到的不是俄语字符，而是坏字符:( 如何在 Excel 2010 中打开此文件？我尝试通过 notepad++ 将 xls 文件从 ANSI 转换为 UTF-8，但无法转换此文件:(
I have excel file with ANSI encoding(it was generated in Excel 97), but now i need open this file with Excel 2010, but seems it have problem with opening ANSI encoding, because instead of russian characters i see bad characters :(
How can i open this file in Excel 2010 ? I tried convert xls file from ANSI to UTF-8 via notepad++ but it can't convert this file :(
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
这是因为您的 PC 上的默认语言设置为英语而不是俄语
因此，如果俄语编码为 UTF-8、UTF-16 (Unicode) 或 UTF-32，则您只能阅读俄语
将 ASCII-8 位转换为您必须将俄语文本转为 unicode 衍生物：
1- 复制俄语文本
2- 在 Notepad++ 中，打开新文件，更改编码 ->字符集 ->东欧
3- 粘贴
4- 然后转换为 Unicode，再次进入同一菜单：编码 -> “以 UTF-8 编码”并希望它变得可读
另一个选择是您复制的文件是 UTF-8 但没有字节顺序标记（文件开头的隐藏字符告诉程序该文件是 UTF-8） ...如果是这种情况，某些程序会将编码检测为 ASCII 而不是 UTF-8。要解决此问题，请重复与上述相同的步骤，但在步骤 2 中不要选择“复活节欧洲”，而是选择“ANSI”。
上述步骤适用于大多数语言。您只需在粘贴到记事本++之前猜测原始编码，然后通过同一菜单转换为替代的基于 Unicode 的编码，看看内容是否变得可读。
大多数语言有两种编码形式：
1- 旧的遗留形式，只有 8 位，最初被大多数计算机使用。 8 位仅允许 256 种可能性，其中 128 种是常规拉丁字符和控制字符，最后 128 位根据 PC 语言设置的不同而被读取
2- 新的 Unicode 标准（最高 32 位）为所有当前已知语言以及未来的更多语言中的每个字符提供了唯一的代码。如果文件是 unicode，则任何安装了该语言字体的 PC 都应该可以理解该文件。请注意，即使 UTF-8 也高达 32 位，并且与 UTF-16 和 UTF-32 一样广泛，只是它尝试保留带有拉丁字符的 8 位，只是为了节省磁盘空间
This is because the default language on your PC is set to English not Russian
Therefore you will only be able to read Russian if it were encoded as UTF-8, UTF-16 (Unicode) or UTF-32
To convert the ASCII-8bit-Russian text you have to a unicode derivative:
1- Copy the Russian text
2- In Notepad++, open new file, change Encoding -> Character Sets -> Eastern European
3- Paste
4- Then to convert to Unicode, go again same menu: Encoding -> "Encode in UTF-8" and hopefully it will become readable
Another option is that the file you copied was UTF-8 but without the byte order mark (a hidden character at the beginning of a file telling programs the file is UTF-8)... If that's the case some programs detect the encoding as ASCII instead of UTF-8. To solve repeat same steps as above but in step 2 instead of choosing Easter European, choose ANSI
The above steps apply for most languages. You just need to guess the original encoding before pasting in notepad++, then convert through the same menu to an alternate Unicode-based encoding to see if things become readable.
Most languages exist in 2 forms of encoding:
1- The old legacy form, only 8 bits, was used initially by most computers. 8 bits only allowed 256 possibilities, 128 of them where the regular latin and control characters, the final 128 bits were read differently depending on the PC language settings
2- The new Unicode standard (up to 32 bit) give a unique code for each character in all currently known languages and plenty more to come. if a file is unicode it should be understood on any PC with the language's font installed. Note that even UTF-8 goes up to 32 bit and is just as broad as UTF-16 and UTF-32 only it tries to stay 8 bits with latin characters just to save up disk space