Traceback (most recent call last):
File "C:\Users\jt-z0300\PycharmProjects\pythonProject\main.py", line 42, in
wb = pandas.read_excel(mb)
File "C:\Users\jt-z0300\PycharmProjects\pythonProject\venv\lib\site-packages\pandas\util_decorators.py", line 211, in wrapper
return func(*args, **kwargs)
File "C:\Users\jt-z0300\PycharmProjects\pythonProject\venv\lib\site-packages\pandas\util_decorators.py", line 331, in wrapper
return func(*args, **kwargs)
File "C:\Users\jt-z0300\PycharmProjects\pythonProject\venv\lib\site-packages\pandas\io\excel_base.py", line 482, in read_excel
io = ExcelFile(io, storage_options=storage_options, engine=engine)
File "C:\Users\jt-z0300\PycharmProjects\pythonProject\venv\lib\site-packages\pandas\io\excel_base.py", line 1695, in init
self._reader = self._engines[engine](self._io, storage_options=storage_options)
File "C:\Users\jt-z0300\PycharmProjects\pythonProject\venv\lib\site-packages\pandas\io\excel_openpyxl.py", line 557, in init
super().init(filepath_or_buffer, storage_options=storage_options)
File "C:\Users\jt-z0300\PycharmProjects\pythonProject\venv\lib\site-packages\pandas\io\excel_base.py", line 545, in init
self.book = self.load_workbook(self.handles.handle)
File "C:\Users\jt-z0300\PycharmProjects\pythonProject\venv\lib\site-packages\pandas\io\excel_openpyxl.py", line 568, in load_workbook
return load_workbook(
File "C:\Users\jt-z0300\PycharmProjects\pythonProject\venv\lib\site-packages\openpyxl\reader\excel.py", line 317, in load_workbook
reader.read()
File "C:\Users\jt-z0300\PycharmProjects\pythonProject\venv\lib\site-packages\openpyxl\reader\excel.py", line 276, in read
self.read_manifest()
File "C:\Users\jt-z0300\PycharmProjects\pythonProject\venv\lib\site-packages\openpyxl\reader\excel.py", line 134, in read_manifest
src = self.archive.read(ARC_CONTENT_TYPES)
File "C:\Users\jt-z0300\AppData\Local\Programs\Python\Python39\lib\zipfile.py", line 1463, in read
with self.open(name, "r", pwd) as fp:
File "C:\Users\jt-z0300\AppData\Local\Programs\Python\Python39\lib\zipfile.py", line 1502, in open
zinfo = self.getinfo(name)
File "C:\Users\jt-z0300\AppData\Local\Programs\Python\Python39\lib\zipfile.py", line 1429, in getinfo
raise KeyError(
KeyError: "There is no item named '[Content_Types].xml' in the archive"
检查一下是否文件已经受损，能正常打开吗？
你要打开的文件格式不对，用excel软件打开，然后另存为excel201X来着
看一下文件状态
这是报错翻译的中文结果：
引发键错误(
【KeyError:“存档中没有名为'[Content_Types].xml'的项”】
重点是这个报错，分析原因：文件受损
解决思路：定位文件位置，修复文件
【修复不成功，或者找不到文件位置，还可以尝试：重新创建Content_Types].xml文档】
先看你手动能不能打开文件 别文件是损坏的
很大可能文件格式有问题 比如只是其他文件改了后缀名 或者别的文件转excel 没转好你就直接用代码尝试去打开了
格式不对