写入excel前查重

21fanqie

写入excel前查重：

C=load_workbook(path)
biao2=C['招标公告']
name_list=[]
for name in biao2.iter_rows(min_row=2,min_col=1,max_col=1,values_only=True):
    name_list.append(name[0])
    #print(name[0])
for information in link_need:
    if information[0] not in name_list:
        biao2.append(information)
        #print(information[0])