Bottom line: it is foolish to expect consistent, usable results from Excel files.
Save the data to a csv file, which you can inspect with a text editor, and read it with a data step written along the documentation you get with the file.
(no documentation -> return to sender)
... View more