如果在excel表格中找不到某个值，则使用openpyxl追加一个零。

import openpyxl

workbook = openpyxl.load_workbook('filename.xlsx')

worksheet = workbook['sheetname']

value = '要查找的值'
found = False

for row in worksheet.iter_rows():
    for cell in row:
        if cell.value == value:
            found = True
            break
    if found:
        break

if not found:
    new_row = [0] * worksheet.max_column
    worksheet.append(new_row)

workbook.save('filename.xlsx')