python - openpyxl BadZipFile：保存 xlsx 文件时文件不是 zip 文件

Question

我正在使用 openpyxl 来处理 xlsx 文件。但是当我保存文件时。我收到一个错误。这是我尝试过的：

import openpyxl
import pandas as pd        

myworkbook = openpyxl.load_workbook(r'C:\Users\ULE5KOR\Downloads\Target_100.xlsx')
mysheet = myworkbook['Sheet1']
with open(r'C:\Users\ULE5KOR\Documents\INTERNSHIP_FILES\WIP_master\dimensions','r+') as f:
        data = f.readlines()
        line_list = [0, 1, 2, 3]
        for line_no in line_list:
                temp = data[line_no]
                mycell = mysheet.cell(row = 260, column = line_no + 14)    
                mycell.value = temp
myworkbook.save(filename = r'C:\Users\ULE5KOR\Downloads\Target_100.xlsx')

错误 ：

Traceback (most recent call last):

  File "<ipython-input-62-354064d42991>", line 13, in <module>
    myworkbook = openpyxl.load_workbook(r'C:\Users\ULE5KOR\Downloads\Target_100.xlsx')

  File "C:\Program Files\Anaconda3\lib\site-packages\openpyxl\reader\excel.py", line 311, in load_workbook
    data_only, keep_links)

  File "C:\Program Files\Anaconda3\lib\site-packages\openpyxl\reader\excel.py", line 126, in __init__
    self.archive = _validate_archive(fn)

  File "C:\Program Files\Anaconda3\lib\site-packages\openpyxl\reader\excel.py", line 98, in _validate_archive
    archive = ZipFile(filename, 'r')

  File "C:\Program Files\Anaconda3\lib\zipfile.py", line 1225, in __init__
    self._RealGetContents()

  File "C:\Program Files\Anaconda3\lib\zipfile.py", line 1292, in _RealGetContents
    raise BadZipFile("File is not a zip file")

BadZipFile: File is not a zip file

注意：我尝试了这个问题的所有建议，但没有一个对我有用。

标签： pythonexcelopenpyxlxlsx