代码如下:
import openpyxl as ops
import gc
wb02=ops.load_workbook(“G:/Python/Project/data.xlsx”)
ws01=wb02.worksheets[0]
rows_num=ws01.max_row
cols_num=ws01.max_column
print(rows_num,cols_num)
for i in range (rows_num):
if i==0:
print("")
else:
b=ws01.cell(i,7).value
c=ws01.cell(i,18).value
if “Asia” in b and c is None and “Video” in c:
ws01.cell(i,23,“1”)
wb02.save(“G:/Python/Project/test.xls”)
del wb02,ws01
gc.collect()
报错如下:
Traceback (most recent call last):
File “E:/Program Files/Python/123.py”, line 19, in
wb02.save(“G:/Python/Project/Amcrest.xls”)
File “C:\Users\Raytine\AppData\Local\Programs\Python\Python38\lib\site-packages\openpyxl\workbook\workbook.py”, line 392, in save
save_workbook(self, filename)
File “C:\Users\Raytine\AppData\Local\Programs\Python\Python38\lib\site-