报错：import_optional_dependency("xlrd", extra=err_msg) File "E:\apps\Anaconda3\envs\learn\lib\site-packages\pandas\compat\_optional.py", line 109, in import_optional_dependency raise ImportError(msg) from None ImportError: Missing optional dependency 'xlrd'. Install xlrd >= 1.0.0 for Excel support Use pip or conda to install xlrd.
原因：
缺少xlrd模块
解决方案：

pip install xlrd

到这里，继续运行读取excel的程序，有的朋友的问题还没有解决，并且报错：f"Your version of xlrd is {xlrd_version}. In xlrd >= 2.0, " ValueError: Your version of xlrd is 2.0.1. In xlrd >= 2.0, only the xls format is supported. Install openpyxl instead.

请安装openpyxl模块

pip install openpyxl

安装完之后：

import pandas as pd
data=pd.read_excel('data/test/data.xlsx')
print(data)

执行此代码，发现可以正常读取文件内容