openpyxl load_workbook加载excel报错zipfile.BadZipFile: File is not a zip file

最新推荐文章于 2024-09-02 13:41:59 发布

暗夜辰星

最新推荐文章于 2024-09-02 13:41:59 发布

阅读量2k

点赞数 1

文章标签： python excel

本文链接：https://blog.csdn.net/weixin_42492572/article/details/132640255

版权

文章讲述了在使用openpyxl的load_workbook函数加载通过VSCode创建的Excel文件时遇到的BadZipFile错误，指出非VSCode工具创建的文件可以正常加载，且提到了可能的原因和解决方案。

摘要由CSDN通过智能技术生成

问题

使用openpyxl load_workbook函数加载已存在的excel文件，出现一些报错：

Traceback (most recent call last):
  File "test1.py", line 28, in <module>
    split_excel("./test2.xlsx")
  File "test1.py", line 14, in split_excel
    wb = load_workbook(file_path)
  File "D:\softwares\Env\Python3\lib\site-packages\openpyxl\reader\excel.py", line 344, in load_workbook
    reader = ExcelReader(filename, read_only, keep_vba,
  File "D:\softwares\Env\Python3\lib\site-packages\openpyxl\reader\excel.py", line 123, in __init__
    self.archive = _validate_archive(fn)
  File "D:\softwares\Env\Python3\lib\site-packages\openpyxl\reader\excel.py", line 95, in _validate_archive
    archive = ZipFile(filename, 'r')
  File "D:\softwares\Env\Python3\lib\zipfile.py", line 1269, in __init__
    self._RealGetContents()
  File "D:\softwares\Env\Python3\lib\zipfile.py", line 1336, in _RealGetContents
    raise BadZipFile("File is not a zip file")
zipfile.BadZipFile: File is not a zip file