from openpyxl.reader.excel import load_workbook


wb2 = load_workbook(filename = 'sebes.xlsx')
wb3 = load_workbook(filename = 'ishod.xlsx')
ws2 = wb2.active
ws3 = wb3.active

def find_sebes(arg):
    slovar = dict(arg)
    for row in ws3.iter_rows():
        shtrih = str(row[0].value)
        sebes = slovar.get(shtrih)
        row[7].value = sebes


def create_list():
    data = []
    for row in ws2.values:
        shtrih = str(row[0])
        sebes = row[6]
        data.append((shtrih, sebes))
    return data




find_sebes(create_list())


wb2.close()
wb3.save('test.xlsx')
wb3.close()