The reason is that pip is installed with the latest version 2.0.1 and only supports. XLS files. So pandas.read_ Excel (‘xxx. Xlsx ‘) will report an error.

You can install the old version xlrd and execute the command in CMD:

pip uninstall xlrd
pip install xlrd==1.2.0

Solved the error report!