抽题的源码

之前学校组织比赛，让我写一个关于抽题的程序，本来想直接在网上找源码，结果真的没找到，于是自己就写了一个

import pandas as pd
import random
import tkinter as tk
from tkinter import filedialog
import time
selected_row_global = None
answer_displayed = False
def random_row_from_excel(file_path, sheet_name):
    df = pd.read_excel(file_path, sheet_name=sheet_name)
    selected_row = df.sample(n=1)
    return selected_row
def browse_file():
    file_path = filedialog.askopenfilename(filetypes=[("Excel files", "*.xlsx;*.xls")])
    entry_file_path.delete(0, tk.END)
    entry_file_path.insert(0, file_path)


def extract_and_display():
    global selected_row_global
    global answer_displayed

    file_path = entry_file_path.get()
    sheet_name = "Sheet1"

    if not file_path:
        result_var.set("请提供文件路径。")
        return

    try:
        selected_row = random_row_from_excel(file_path, sheet_name)
        question = selected_row.iloc[0, 0]
        option_A = selected_row.iloc[0, 2]
        option_B = selected_row.iloc[0, 3]
        option_C = selected_row.iloc[0, 4]
        option_D = selected_row.iloc[0, 5]

        # Clear previous results
        result_text.delete(1.0, tk.END)

        # Display the question and options
        result_text.insert(tk.END, f"问题：{question}\n")
        result_text.insert(tk.END, f"A：{option_A}\n")
        result_text.insert(tk.END, f"B：{option_B}\n")
        result_text.insert(tk.END, f"C：{option_C}\n")
        result_text.insert(tk.END, f"D：{option_D}\n")


        # 保存选中的行和标志
        selected_row_global = selected_row
        answer_displayed = False
    except Exception as e:
        result_text.delete(1.0, tk.END)
        result_text.insert(tk.END, f"发生错误：{e}")


def show_answer():
    global answer_displayed

    if not answer_displayed and selected_row_global is not None:
        display_column_2 = selected_row_global.iloc[0, 6]
        result_var.set(f"答案：{display_column_2}")
        countdown_var.set("")
        answer_displayed = True
def clear_result():
    result_var.set("")
    print()
def clear_answer():
    global selected_row_global
    global answer_displayed

    result_var.set("")  # 清空显示答案的变量
    selected_row_global = None
    answer_displayed = False

root = tk.Tk()
root.title("随机选择Excel行")
font_size = 20
font = ('heiti', font_size)
result_text = tk.Text(root, wrap=tk.WORD, font=font)  # 设置自动换行
result_text.grid(row=2, column=0, columnspan=3, padx=10, pady=10, sticky="W")
label_file_path = tk.Label(root, text="文件路径:", font=font)  # 修改字体大小
label_file_path.grid(row=0, column=0, padx=10, pady=10, sticky="E")
entry_file_path = tk.Entry(root, width=50, font=font)  # 修改字体大小
entry_file_path.grid(row=0, column=1, padx=10, pady=10, sticky="W")
button_browse = tk.Button(root, text="浏览", command=browse_file, font=font)  # 修改字体大小
button_browse.grid(row=0, column=2, padx=10, pady=10)
button_extract = tk.Button(root, text="抽取", command=extract_and_display, font=font)  # 修改字体大小
button_extract.grid(row=1, column=0, columnspan=3, pady=20)
button_show_answer = tk.Button(root, text="显示答案", command=show_answer, font=font)
button_show_answer.grid(row=1, column=2, pady=20)
button_clear_answer = tk.Button(root, text="清除答案", command=clear_answer, font=font)
button_clear_answer.grid(row=1, column=3, pady=20)
result_var = tk.StringVar()
result_label = tk.Label(root, textvariable=result_var, justify="left", font=font)  # 修改字体大小
result_label.grid(row=2, column=0, columnspan=3, padx=10, pady=10, sticky="W")
countdown_var = tk.StringVar()
countdown_label = tk.Label(root, textvariable=countdown_var, font=font)  # 修改字体大小
countdown_label.grid(row=0, column=3, rowspan=3, padx=10, pady=10, sticky="E")
root.update_idletasks()
screen_width = root.winfo_screenwidth()
screen_height = root.winfo_screenheight()
x_coordinate = (screen_width - root.winfo_reqwidth()) / 2
y_coordinate = (screen_height - root.winfo_reqheight()) / 2
root.geometry("+%d+%d" % (x_coordinate, y_coordinate))
root.mainloop()

运行结果成这样子

抽取的xls这样子写