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

最新推荐文章于 2024-07-18 13:55:21 发布

编程答疑

最新推荐文章于 2024-07-18 13:55:21 发布

阅读量2.1k

点赞数 9

CC 4.0 BY-SA版权

文章标签： python excel 开发语言

本文链接：https://blog.youkuaiyun.com/tangshengshan870823/article/details/135359752

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

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

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