It is normal to import XLS files previously using Mathematica 11.3!
However, when I import XLS files these days, I don’t know why there is always an error message. Is there a way to check the cause of the error?
Import["C:\\Users\\prede\\20130424.xls"]
wrong information: Import::fmterr: Cannot import data as XLS format.
20130424.xls (1.28 MB)
Is Import["C:\\Users\\prede\\20130424.xls"] actually the full path on your machine? or is it something else? I believe there is an issue where in Mathematica 11.3 (Windows only) Import is unable to properly bring in .xls/.xlsx files if they have a non-ASCII character in the file path.
If this in fact the issue, you may be able to use Import[filepath", "DataLegacy"] to bring the data in as a workaround.
If the above isn’t helpful then I’d recommend contacting support (Contact Wolfram Support by Email or Phone) and they should be able to assist further.
Thank for your reminder~~
In fact, in my file path contains the non-ASCII character. After the correction, I can Import XLS files~~
But I am surprised that ~~~ Why the error message does not show “Cannot find the file,” but show “Cannot import data as XLS format.”
It does not quite match the intuition of file path errors.
Import should be able to handle this, which is why there isn’t a proper error message I believe. If it were an intended limitation it would likely be better documented. In any event we’re looking to address this in a future release.
