pip install xlrd
pip install  python-docx

#!/bin/bash env python
import xlrd
import  random
from  docx import  Document
from docx.shared import Pt, RGBColor
from docx.enum.text import  WD_ALIGN_PARAGRAPH

#打開(kāi)excel
data = xlrd.open_workbook('data.xls')
#獲取工作表
sheet = data.sheet_by_index(0)

class Question:
   pass
def create_question():
   question_list = []
   for i in range(sheet.nrows):
       if i>2:
             #創(chuàng)建試題類(lèi)
             question = Question()
             question.ID = sheet.cell(i,0).value
             #添加試題的題目信息
             question.subject = sheet.cell(i,1).value
             #添加題目類(lèi)型
             question.question_type = sheet.cell(i,2).value
             #添加試題選項(xiàng)
             question.option = []
             question.option.append(sheet.cell(i, 3).value)  # A
             question.option.append(sheet.cell(i, 4).value)  # B
             question.option.append(sheet.cell(i, 5).value)  # C
             question.option.append(sheet.cell(i, 6).value)  # D
             #添加分值
             question.score = sheet.cell(i,7).value
             question_list.append(question)
   #將試卷題目隨機(jī)打亂并且返回
   random.shuffle(question_list)
   return question_list

def create_papper(file_name,paper_name,question_list):
    #創(chuàng)建一個(gè)文檔對(duì)象
    document = Document()
    #設(shè)置頁(yè)眉的位置信息
    section = document.sections[0]
    header = section.header
    p1 = header.paragraphs[0]
    p1.text = paper_name
    #設(shè)置頁(yè)腳信息
    footer = section.footer
    p2 = footer.paragraphs[0]
    p2.text = '內(nèi)部試題，禁止泄露'
    #寫(xiě)入試卷基本信息
    titile = document.add_heading(paper_name,level=1)
    #設(shè)置對(duì)齊方式
    titile.alignment = WD_ALIGN_PARAGRAPH.CENTER
    #添加一個(gè)段落
    p3 =  document.add_paragraph()
    p3.add_run('姓名:____')
    p3.add_run('班級(jí):____')
    p3.alignment =  WD_ALIGN_PARAGRAPH.CENTER
    #寫(xiě)入試題信息
    for i,question in enumerate(question_list):
        subject_paragraph = document.add_paragraph() #添加一個(gè)段落
        run = subject_paragraph.add_run(str(i+1)+str(question.subject)) #添加題目信息
        run.bold = True #設(shè)置加粗
        subject_paragraph.add_run('【%s】分'%str(question.score))
        #打亂選項(xiàng)的順序
        random.shuffle(question.option)
        for index,option in enumerate(question.option):
            document.add_paragraph(('ABCD')[index]+str(option))
    #保存試題
    document.save(file_name)
    return

if __name__ == '__main__':
    question_list = create_question()
    #循環(huán)生成100份試卷
    for item in range(1,100):
        create_papper('2021第'+str(item)+'套內(nèi)部考試試題.docx','2021第一季度內(nèi)部考試',question_list)
    print('over')