日常随笔——如何把excel题库转换为word打印格式

将Excel题库转换为Word可以通过编程的方式实现。以下是一个使用Python的示例代码，该代码使用openpyxl库读取Excel文件，并使用python-docx库创建和保存Word文档。

首先，请确保已经安装了 openpyxl 和 python-docx 库。可以使用以下命令进行安装：

pip install openpyxl python-docx

然后，使用以下代码将Excel题库转换为Word文档：

import openpyxl
from docx import Document
from docx.shared import Ptdef excel_to_word(excel_file, word_file):# 打开Excel文件wb = openpyxl.load_workbook(excel_file)# 获取第一个工作表sheet = wb.activecount = 1# 创建Word文档doc = Document()first_line = True# 遍历Excel表格中的每一行for row in sheet.iter_rows(values_only=True):# 跳过首行if first_line:first_line = Falsecontinue# 第一列为问题，第二列为答案question = row[0]answer_mode = row[1]answer_choice = row[3]answer = row[4]answer_choices = answer_choice.split("|")if len(answer_choices) == 1:answer_choices = answer_choice.split("｜")choice  = ""C = ["A", "B", "C", "D", "E", "F", "G"]for index, value in enumerate(answer_choices):choice += C[index] + ": " + str(value) + "   "# 调整间距# doc.paragraph_format.space_before = Pt(12)  # 段前12磅# doc.paragraph_format.space_after = Pt(12)   # 段后12磅# 将问题和答案写入Word文档doc.add_paragraph(f"问题{count}: {question}({answer_mode}) \n选项: {choice} \n答案: {answer}")# doc.add_paragraph(f"选项: {choice}")# doc.add_paragraph(f"答案: {answer}")# 添加分隔线# doc.add_paragraph("--------------------")count += 1# 保存Word文档doc.save(word_file)# 设置Excel和Word文件的路径
excel_file = "复习资料.xlsx"
word_file = "题库.docx"# 调用函数将Excel题库转换为Word文档
excel_to_word(excel_file, word_file)