AttributeError: 'int' object has no attribute 'find'

python匹配txt和Excel,按txt内容提取Excel中含关键词的行

这是报错:

img

源码如下:

def get_key_list(txt_file):
    try:
        file_data = open(txt_file, 'r')
        list1 = file_data.readlines()
        key_list = [k.strip('\n') for k in list1]
        return key_list
    except:
        pass
    return []


def xls_select(xls_sr, xls_tg, key_list):
    from openpyxl import Workbook
    from openpyxl import load_workbook
    # 只处理第一个工作表 , 数据在第一列
    wb = load_workbook(xls_sr)
    ws = wb[wb.sheetnames[0]]
    wb_tg = Workbook()
    sheet_tg = wb_tg.active
    sheet_tg.title = "Data Select"
    save_i = 0
    for row in ws.rows:
        for k in key_list:
            if row[0].value.find(k) >= 0:
                sheet_tg["A%d" % (save_i + 1)].value = row[0].value
                save_i = save_i + 1

    wb_tg.save(xls_tg)
    wb.close()
    wb_tg.close()

key_list = get_key_list('关键词.txt')
xls_select('总数据.xlsx','286.xlsx', key_list)

关键词txt:

img

兄弟~row[0].value的值是个数字,哪来的find函数。
异常信息都告诉你答案了