使用python在excel中删除具有特定列组合的重复行

import openpyxl
from openpyxl import load_workbook

workbook = load_workbook('file_name.xlsx')
sheet = workbook['sheet_name']

seen_combinations = set()

for row in sheet.iter_rows(min_row=2, values_only=True):
    # 获取指定列的值
    column1_value = row[0]
    column2_value = row[1]
    # 组合列的值
    combination = (column1_value, column2_value)
    # 如果组合已经出现过，则删除该行
    if combination in seen_combinations:
        sheet.delete_rows(row[0].row)
    else:
        seen_combinations.add(combination)

workbook.save('file_name.xlsx')