我正在尝试将单元格从大型excel文件复制到另一个大型excel文件,这两个文件都是.xlsx。我正在使用openpyxl模块。以下是我的代码:
>>> import openpyxl
>>> wb1=openpyxl.load_workbook('File1.xlsx',read_only=True)
错误:
Traceback (most recent call last):
File "C:\Users\U6038633\AppData\Local\Programs\Python\Python36-32\lib\site-packages\openpyxl\reader\excel.py", line 118, in _validate_archive
archive = ZipFile(filename, 'r', ZIP_DEFLATED)
File "C:\Users\U6038633\AppData\Local\Programs\Python\Python36-32\lib\zipfile.py", line 1108, in __init__
self._RealGetContents()
File "C:\Users\U6038633\AppData\Local\Programs\Python\Python36-32\lib\zipfile.py", line 1175, in _RealGetContents
raise BadZipFile("File is not a zip file")
zipfile.BadZipFile: File is not a zip file
在处理上述异常期间,发生了另一个异常:
Trac