当使用openpyxl load_workbook函数加载excel工作簿时,"BadZipFile: File不是zip文件“将面临错误。如何解决此错误?
workbook = r'C:\Desktop\Test.xlsx'
worksheet = 'Data'
# create a Pandas Excel writer using XlsxWriter as the engine.
writer = pd.ExcelWriter(workbook, engine='openpyxl')
wb = load_workbook(workbook)
writer.book = workbook
writer.sheets = {x.title: x for x in wb.worksheets}
ws = writer.sheets[worksheet]
for i in range(len(vehicle_sales)):
row = list(vehicle_sales.iloc[i])
for j in range(len(vehicle_sales.columns)):
value = row[j]
ws.cell(i+2, j+1, value)
xl.writer.excel.save_workbook(wb, workbook)
发布于 2022-07-11 14:25:42
excel文件处于只读模式。我将该文件保存为一个新文件,load_workbook工作了。
https://stackoverflow.com/questions/72939973
复制相似问题