openpyxl模块--------------------------------重复数据

测试数据

 

上代码：

from  openpyxl import load_workbook
from openpyxl.styles import PatternFill

def dum():
    wb = load_workbook("C:/Users/admin/Desktop/打卡时间.xlsx")
    sh = wb.active
    ##存储哪一行的重复数据
    index = []
    tmp = [] #没有重复的数据
    for i,c in enumerate(sh['B']):
        flag = c.value not in tmp
        print(flag,f'===={c}========={tmp}')
        if flag:


        #if c not in tmp:
             tmp.append(c.value)
        else:
            index.append(i)
    fill = PatternFill('solid',fgColor='AEEEEE')
    for i,r in enumerate(sh.rows):
        if i in  index:
            for c in r:
                c.fill = fill
            print(f'第{i+1}条数据是重复的')
    wb.save('C:/Users/admin/Desktop/重复shuju.xlsx')


if __name__ == "__main__":
    dum()
实现效果：

 ###################################删除重复值

from  openpyxl import load_workbook
from openpyxl.styles import PatternFill

def dum():
    wb = load_workbook("C:/Users/admin/Desktop/打卡时间.xlsx")
    sh = wb.active
    ## 创建一个集合来存放已经遇到过的值
    seen_values = set()

   # 从最后一行开始向上遍历每一行
    for row in range(sh.max_row, 0, -1):
         for column in sh[row]:
             value = str(column.value) # 将单元格内容转换为字符串类型

             if value not in seen_values and value != '':
                 seen_values.add(value)
             else:
                 # 移动当前行并删除该行
                 sh.delete_rows(row)
    wb.save('C:/Users/admin/Desktop/delete.xlsx')


if __name__ == "__main__":
    dum()
测试数据：

 

获得的结果：