def get_students_name():
    # 學生名單中需要有"姓名"列
    workbook = openpyxl.load_workbook('學生名單.xlsx')
    table = workbook.active
    rows, cols = table.max_row, table.max_column
    name_col = 0
    for col in range(cols):
        if table.cell(1, col + 1).value == '姓名':
            name_col = col
            break
    students_name = [table.cell(row+1, name_col+1).value for row in range(1, rows)
                     if table.cell(row+1, name_col+1).value is not None]
    return students_name

if __name__ == '__main__':
    window = tk.Tk()
    window.geometry('600x400+400+180')
    window.title('\t 第一屆LOL點名系統(tǒng)')
    # 添加背景圖片
    bg_png = tk.PhotoImage(file="背景圖片.png")
    bg_label = Label(window, image=bg_png)
    bg_label.pack()
    # 添加顯示框
    var = StringVar(value='公平 公正 公開')
    show_label1 = Label(window, textvariable=var, justify='left', anchor=CENTER, width=16,
                        height=2, font='楷體 -40 bold', foreground='white', bg='#1C86EE')
    show_label1.place(anchor=tk.NW, x=130, y=90)
    # 添加點名按鈕
    button_png = tk.PhotoImage(file='button.png')
    button = Button(window, text='點 名', compound='center', font='楷體 -30 bold',
                    foreground='#9400D3', image=button_png,
                    command=lambda: call_lucky_student(var))
    button.place(anchor=NW, x=235, y=200)
    # 顯示窗口
    window.mainloop()

def call_lucky_student(var):
    """點名"""
    global is_run
    if is_run:
        return
    is_run = True
    start = time.time()
    choice_student(var, start)


def choice_student(var, start):
    global is_run
    show_member = random.choice(get_students_name())
    name = show_member[0]
    for zi in show_member[1:]:
        name += ' ' + zi
    var.set(name)
    end = time.time()
    if is_run and end-start <= 5:
        window.after(30, choice_student, var, start)
    else:
        is_run = False
        return