使用Python读取Excel时报错zipfile.BadZipFile: File is not a zip file

最新推荐文章于 2024-07-09 15:37:54 发布

原创最新推荐文章于 2024-07-09 15:37:54 发布 · 2.3k 阅读

7 ·

CC 4.0 BY-SA版权

文章标签：

#python #excel #开发语言

文章描述了在使用Python库openpyxl处理XLSX文件时遇到的错误，原因是尝试打开的文本文件实际上是.txt，而非真正的.xlsx格式。解决方法是确保文件正确为.xlsx，或者使用其他如WPS软件创建的文件。

Traceback (most recent call last):
  File "/Users/long3/workspace/usefullc/electron-xls/backend/test/testXls.py", line 41, in <module>
    generate_excel_from_template(template_path, output_path, excel_data)
  File "/Users/long3/workspace/usefullc/electron-xls/backend/test/testXls.py", line 6, in generate_excel_from_template
    template = load_workbook(template_path)
  File "/Library/Frameworks/Python.framework/Versions/3.8/lib/python3.8/site-packages/openpyxl/reader/excel.py", line 344, in load_workbook
    reader = ExcelReader(filename, read_only, keep_vba,
  File "/Library/Frameworks/Python.framework/Versions/3.8/lib/python3.8/site-packages/openpyxl/reader/excel.py", line 123, in __init__
    self.archive = _validate_archive(fn)
  File "/Library/Frameworks/Python.framework/Versions/3.8/lib/python3.8/site-packages/openpyxl/reader/excel.py", line 95, in _validate_archive
    archive = ZipFile(filename, 'r')
  File "/Library/Frameworks/Python.framework/Versions/3.8/lib/python3.8/zipfile.py", line 1269, in __init__
    self._RealGetContents()
  File "/Library/Frameworks/Python.framework/Versions/3.8/lib/python3.8/zipfile.py", line 1336, in _RealGetContents
    raise BadZipFile("File is not a zip file")
zipfile.BadZipFile: File is not a zip file

因为自己手动在磁盘中建立一个txt 文件，但是后缀确实xlsx. 导致文件格式不兼容。如下图所示：大小为0