This section provides a tutorial example to prove that Excel can not open a UTF-16LE text file. Its Text Import Wizard only supports UTF-7 and UTF-8 encodings.
In the next test, I want to use Excel to open the UTF-16LE text file, hello.utf-16le, created from the previous chapter.
1. Run Excel and click menu File > Open. The Open file dialog box comes up.
2. Select the hello.utf-16le text file and click the Open button.
A warning message dialog box comes up.
I tried clicking OK to use the Text Import Wizard.
But Excel does not provide the UTF-16LE encoding in the "File origin" list.
Too bad. This proves that Excel can not open UTF-16LE text files.