用 Python 把 EXCEL 题库 转Word文档

from docx import Document
import openpyxl
import random

def generate_exam():
    # 单选题随机抽取
    def danxuan(num_questions):
        workbook = openpyxl.load_workbook('danxuan.xlsx')
        sheet = workbook.active
        questions = []
        for row in sheet.iter_rows(min_row=2, max_row=sheet.max_row, values_only=True):
            question = {
                '类型': row[0],
                '序号': row[1],
                '题干': row[2],
                'A': row[3],
                'B': row[4],
                'C': row[5],
                'D': row[6],
                '正确答案': row[7]
            }
            questions.append(question)

        selected_questions = random.sample(questions, num_questions)
        return selected_questions

    # 判断题随机抽取
    def panduan(num_questions):
        workbook = openpyxl.load_workbook('panduan.xlsx')