テスト

def words_test():
    excel = file.get()
    wb = px.load_workbook(excel)
    sheetnames = wb.sheetnames
    ws_1 = wb[sheetnames[0]]
    ws_2 = wb[sheetnames[1]]
    ws_3 = wb[sheetnames[2]]
    ws_4 = wb[sheetnames[3]]
    last_row = ws_1.max_row
    keys_list = []
    values_list = []

    for i in range(2, last_row + 1):
        keys = ws_1.cell(row = i, column = 1 ).value
        values = ws_1.cell(row = i, column = 3 ).value
        keys_list.append(keys)
        values_list.append(values)

    word_dic = dict(zip(keys_list, values_list))

    count = 2
    while count < 12:
        en, jp = random.choice(list(word_dic.items()))
        ws_2.cell(row = count, column = 1).value = en
        ws_3.cell(row = count, column = 2).value = jp
        ws_4.cell(row = count, column = 1).value = en
        ws_4.cell(row = count, column = 2).value = jp
        count += 1

    wb.save(excel)