File "C:\Users\lxx\AppData\Local\Programs\Python\Python39\lib\site-packages\openpyxl\reader\excel.py", line 315, in load_workbook
reader = ExcelReader(filename, read_only, keep_vba,
File "C:\Users\lxx\AppData\Local\Programs\Python\Python39\lib\site-packages\openpyxl\reader\excel.py", line 124, in init
self.archive = _validate_archive(fn)
File "C:\Users\lxx\AppData\Local\Programs\Python\Python39\lib\site-packages\openpyxl\reader\excel.py", line 96, in _validate_archive
archive = ZipFile(filename, 'r')
File "C:\Users\lxx\AppData\Local\Programs\Python\Python39\lib\zipfile.py", line 1239, in init
self.fp = io.open(file, filemode)
怎么办,急救
应该是你python环境问题,你试试卸载python,将python安装在D盘
从提供的信息看,openpyxl已经安装了,这个不是安装时报错,而是在调用它时报错,检查一下出错代码和具体的报错信息。
相关的出错问题可能与pandas有关,可参考这里解决办法:
https://stackoverflow.com/questions/66471466/openpyxl-load-workbook-on-a-legit-xlsx-file-leads-to-a-zipfile-badzipfile-err/66472617#66472617
在读取xlsx文件时指定一下engine和mode:
writer = pd.ExcelWriter(filename, engine='openpyxl', mode='a')