讨论区 老师答疑区 主题详情
杜松松ykt68714551596706333
openpyxl 打开excel文件出现这样的错误

Traceback (most recent call last):

  File "E:\python\python对excel\第一节.py", line 2, in <module>

    wb = openpyxl.load_workbook("567.xlsx")

  File "E:\python\venv\lib\site-packages\openpyxl\reader\excel.py", line 315, in load_workbook

    reader = ExcelReader(filename, read_only, keep_vba,

  File "E:\python\venv\lib\site-packages\openpyxl\reader\excel.py", line 124, in __init__

    self.archive = _validate_archive(fn)

  File "E:\python\venv\lib\site-packages\openpyxl\reader\excel.py", line 96, in _validate_archive

    archive = ZipFile(filename, 'r')

  File "D:\Program Files\python\lib\zipfile.py", line 1257, in __init__

    self._RealGetContents()

  File "D:\Program Files\python\lib\zipfile.py", line 1324, in _RealGetContents

    raise BadZipFile("File is not a zip file")

zipfile.BadZipFile: File is not a zip file


课程

所有回复(0)

回复

最近活动:
创建时间:
浏览次数:87
关注人数:0