pip install openpyxl pygame requests 

import tkinter as tk
from tkinter import ttk, messagebox
from openpyxl import load_workbook
import random
import os,re
import pygame,requests
from io import BytesIO
from threading import Lock, Thread, Timer
 
def load_excel_data(filename):
    workbook = load_workbook(filename)
    sheet = workbook.active
    questions = []
    lessons = set()  # 用于存儲所有課程名，避免重復
    for row in sheet.iter_rows(min_row=2, values_only=True):
        lesson = row[0]
        lessons.add(lesson)
        question = {
            '單元': lesson,
            '序號': row[1],
            '題干': row[2],
            '選項': [row[3], row[4], row[5], row[6]],
            '正確答案': row[7]
        }
        questions.append(question)
    return list(lessons), questions
 
lessons, questions = load_excel_data('選擇題.xlsx')
random.shuffle(questions)
 
# 使用正則表達式從課程名中提取數(shù)字，并按數(shù)字排序課程名
sorted_lessons = sorted(lessons, key=lambda x: (lambda m: int(m.group(0)) if m else 0)(re.search(r'\d+', x)))
 
class QuizApp:
    def __init__(self, root):
        self.root = root
            # 設置窗口大小
        self.root.geometry("600x500")
        #self.root.resizable(False, False)
        pygame.init()
        self.all_questions = questions
        self.questions = questions  # 當前顯示的問題列表
        self.current_question_index = 0
        self.correct_answers = 0
        self.wrong_answers = 0
        self.error_questions = []
        self.setup_ui()
        self.load_question()
        
    def thread_it(self,func):
        self.thread1=Thread(target=func)
        self.thread1.setDaemon(True) 
        self.thread1.start()
 
    def setup_ui(self):
        self.root.title("選擇題訓練工具")
        self.lesson_combobox = ttk.Combobox(self.root, values=['全部'] + sorted_lessons, state="readonly")
        self.lesson_combobox.pack(pady=(10, 0))
        self.lesson_combobox.set('全部')
        self.lesson_combobox.bind('<<ComboboxSelected>>', self.on_combobox_change)
        self.question_label = tk.Label(self.root, text="", font=("Times New Roman", 20), fg="blue", wraplength=520, justify=tk.LEFT) #設置文本長度，并且文本左對齊
        self.question_label.pack(pady=(10, 40))
 
        self.options_frame = tk.Frame(self.root)
        self.options_frame.pack(pady=20)
 
        option_labels = ['A', 'B', 'C', 'D']  # 選項標簽
        self.option_buttons = []  # 存儲選項按鈕
        self.option_labels = []  # 存儲選項標簽控件
 
        for i in range(4):
            # 創(chuàng)建選項標簽控件并放置
            label = tk.Label(self.options_frame, text=f"{option_labels[i]}.", font=("Times New Roman", 16))
            label.grid(row=i, column=0, pady=5, sticky="e")
            self.option_labels.append(label)
            
            # 創(chuàng)建選項按鈕并放置
            btn = tk.Button(self.options_frame, text="", font=("Times New Roman", 16), width=20,
                command=lambda b=i: self.check_answer(b),  # type: ignore
                anchor="w")
 
 
            btn.grid(row=i, column=1, pady=5)
            self.option_buttons.append(btn)
 
        self.action_frame = tk.Frame(self.root)
        self.action_frame.pack(side=tk.BOTTOM, pady=20)
        tk.Button(self.action_frame, text="退出程序", font=("宋體", 16, "bold"), width=9, command=self.ui_quit).pack(side=tk.LEFT, padx=10)
        tk.Button(self.action_frame, text="我的戰(zhàn)績", font=("宋體", 16, "bold"), width=9, command=self.show_score).pack(side=tk.LEFT, padx=10)
        tk.Button(self.action_frame, text="查看錯誤", font=("宋體", 16, "bold"), width=9, command=self.show_errors).pack(side=tk.LEFT, padx=10)
        tk.Button(self.action_frame, text="朗讀題干", font=("宋體", 16, "bold"), width=9, command=self.show_sound).pack(side=tk.LEFT, padx=10)# 其余UI代碼與原來相同...
 
    def on_combobox_change(self, event):
        selected_lesson = self.lesson_combobox.get()
        if selected_lesson == '全部':
            self.questions = self.all_questions
        else:
            self.questions = [q for q in self.all_questions if q['單元'] == selected_lesson]
        self.current_question_index = 0
        self.correct_answers = 0
        self.wrong_answers = 0
        self.error_questions = []
        self.load_question()
 
    def load_question(self):
        if self.current_question_index < len(self.questions):
            question = self.questions[self.current_question_index]
            self.question_label.config(text=str(self.current_question_index+1)+". "+question['題干'],anchor='w')
            correct_answer = question['正確答案']
            options = question['選項']
            self.correct_option_index = options.index(correct_answer)
            random.shuffle(options)
 
            for i, option in enumerate(options):
                self.option_buttons[i].config(text=option, bg='SystemButtonFace')
 
    def check_answer(self, button_index):
        question = self.questions[self.current_question_index]
        selected_option = self.option_buttons[button_index].cget('text')
        correct_option = question['正確答案']
        
        # 確定正確答案按鈕的索引
        correct_option_index = None
        for i, btn in enumerate(self.option_buttons):
            if btn.cget('text') == correct_option:
                correct_option_index = i
                break
 
        if selected_option == correct_option:
            # 用戶選擇了正確的答案
            self.option_buttons[button_index].config(bg='light green')
            self.correct_answers += 1
        else:
            # 用戶選擇了錯誤的答案
            self.option_buttons[button_index].config(bg='red')
            if correct_option_index is not None:
                self.option_buttons[correct_option_index].config(bg='light green')
            self.wrong_answers += 1
            self.error_questions.append((question['題干'], selected_option, question['正確答案']))
 
        # 準備間隔1秒顯示下一個問題
        self.root.after(1000, self.next_question)
 
 
    def next_question(self):
        self.current_question_index += 1
        if self.current_question_index < len(self.questions):
            self.load_question()
        else:
            messagebox.showinfo("結束", "所有問題都已回答完畢！")
 
    def ui_quit(self):
        self.root.destroy()
 
    def show_score(self):
        messagebox.showinfo("戰(zhàn)績", f"正確: {self.correct_answers}\n錯誤: {self.wrong_answers}\n總計: {len(self.questions)}\n正確率:{self.correct_answers/len(self.questions)*100}%")
    
    def show_sound(self):
        self.thread_it(self.show_sound2)
    
    def show_errors(self):
        error_messages = "\n".join([f"題干: {q[0]},正確答案是：{q[2]}, 您的選擇: {q[1]}" for q in self.error_questions])
        messagebox.showinfo("錯誤回顧", error_messages if error_messages else "完美！沒有任何錯誤。")
 
    def show_sound2(self):
        self.current_name = self.question_label.cget("text")
        audio_path = f"https://dict.youdao.com/dictvoice?audio={self.current_name}&type=1"
        resp = requests.get(audio_path)
        audio_data = BytesIO(resp.content)
        pygame.mixer.music.load(audio_data)
        pygame.mixer.music.play()
        while pygame.mixer.music.get_busy():
            continue
        # 退出pygame
 
if __name__ == "__main__":
    root = tk.Tk()
    app = QuizApp(root)
    root.mainloop()