如何在满足条件的情况下用openpyxl python删除excel中的特定行

from openpyxl import Workbook, load_workbook

workbook = load_workbook('example.xlsx')

worksheet = workbook.active

delete_rows = []
for row in worksheet.iter_rows(min_row=2):  # 从第2行开始遍历
    if row[0].value == '条件':  # 根据自己的条件进行判断
        delete_rows.append(row)

for row in delete_rows:
    worksheet.delete_rows(row[0].row)

# 或者可以使用以下方法删除行，将删除的行保存在列表中，然后再遍历列表删除
# for row in delete_rows[::-1]:  # 反向遍历列表
#     worksheet.delete_rows(row[0].row)

workbook.save('example.xlsx')
workbook.close()