1. zipfile.BadZipFile: File is not a zip file
详细错误:
workbook = load_workbook('test.xlsx')
Traceback (most recent call last):
File "C:\Python 3.6.5\lib\site-packages\openpyxl\reader\excel.py", line 121, in _validate_archive
archive = ZipFile(filename, 'r', ZIP_DEFLATED)
File "C:\Python 3.6.5\lib\zipfile.py", line 1108, in __init__
self._RealGetContents()
File "C:\Python 3.6.5\lib\zipfile.py", line 1175, in _RealGetContents
raise BadZipFile("File is not a zip file")
zipfile.BadZipFile: File is not a zip file
问题描述: 我想利用openpyxl包来读取xlsx文件。 解决方案: 网上的说法是xlsx加密的原因,目前还没解决。