请教各位，python创建excel报错应如何解决？Traceback (most recent call last):

Question

报错如下，请各位帮忙看看

D:\pycharm\project\venv\Scripts\python.exe D:/pycharm/project/pandas玩转excel/如何创建文件.py
Traceback (most recent call last):
  File "D:\pycharm\project\pandas玩转excel\如何创建文件.py", line 4, in <module>
    df.to_excel('D:\Temp\output.xlsx')
  File "D:\pycharm\project\venv\lib\site-packages\pandas\core\generic.py", line 2284, in to_excel
    formatter.write(
  File "D:\pycharm\project\venv\lib\site-packages\pandas\io\formats\excel.py", line 834, in write
    writer = ExcelWriter(  # type: ignore[abstract]
  File "D:\pycharm\project\venv\lib\site-packages\pandas\io\excel\_openpyxl.py", line 48, in __init__
    from openpyxl.workbook import Workbook
ModuleNotFoundError: No module named 'openpyxl'

Process finished with exit code 1

Answer 1

你好同学，你的openpyxl包包可能没有安装，请在cmd命令行下使用

pip install openpyxl

安装openpyxl包包之后，就可以正常使用啦
有帮助望采纳哟，帮助答主冲榜，谢谢啦（づ￣3￣）づ╭❤～