Traceback (most recent call last):
  File "d:/sources/pythons/pandas/test.py", line 18, in <module>
    df.to_excel("people.xlsx")
  File "C:\Program Files\Python38\lib\site-packages\pandas\core\generic.py", line 2026, in to_excel
    formatter.write(
  File "C:\Program Files\Python38\lib\site-packages\pandas\io\formats\excel.py", line 730, in write
    writer = ExcelWriter(stringify_path(writer), engine=engine)
    from openpyxl.workbook import Workbook
ModuleNotFoundError: No module named 'openpyxl'

此时缺少对应的python模块openpyxl，使用以下命令安装即可：

pip install openpyxl

  File "C:\Program Files\Python38\lib\site-packages\pandas\compat\_optional.py", line 110, 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.

people = pd.read_excel("people.xlsx", sheet_name="Sheet1",engine='openpyxl')