利用openpyxl和docx批量生成请假条

一、需求分析

1、excel表中有员工请假汇总表

2、需要每位员工生成请假条

二、程序思路

1、openpyxl读取excel表中的数据

2、docx将读取的数据生成请假条

三、代码实现

from openpyxl import load_workbook

# 读取 Word 文件
from docx import Document
# 文件涉及段落样式修改
from docx.enum.text import WD_PARAGRAPH_ALIGNMENT
# 文件涉及文字样式修改：颜色修改、字号调整
from docx.shared import RGBColor, Pt
# 设置中文字体
from docx.oxml.ns import qn


path = r'C:\Users\MyPC\Desktop\everything\codes'

def request_for_leave(name, department, reason, days, date):
    doc = Document()
    heading_1 = '请 假 条'
    paragraph_1 = doc.add_heading(heading_1, level=1)
    # 居中对齐
    paragraph_1.alignment = WD_PARAGRAPH_ALIGNMENT.CENTER
    # 标题要大，单独修改较大字号
    for run in paragraph_1.runs:
        run.font.size = Pt(17)
    greeting_word = '尊敬的领导：'
    paragraph_2 = doc.add_paragraph(greeting_word)

    word_1 = "    本人"
    word_2 = "，所在部门"
    word_3 = "由于"
    word_4 = "，需请假"
    word_5 = "天。"
    paragraph_3 = doc.add_paragraph()
    paragraph_3.add_run(word_1)
    paragraph_3.add_run(name).underline = True
    paragraph_3.add_run(word_2)
    paragraph_3.add_run(department).underline = True
    paragraph_3.add_run(word_3)
    paragraph_3.add_run(reason).underline = True
    paragraph_3.add_run(word_4)
    paragraph_3.add_run(str(days)).underline = True
    paragraph_3.add_run(word_5)
    # 设置下划线
    paragraph_3.paragraph_format.line_spacing = 1.5

    word_6 = '申请人：'
    paragraph_4 = doc.add_paragraph()
    paragraph_4.add_run(word_6)
    paragraph_4.add_run(name).underline = True
    paragraph_4.alignment = WD_PARAGRAPH_ALIGNMENT.RIGHT

    word_7 = '日期：'
    sign_date = "{}年{}月{}日".format(date.split('-')[0], date.split('-')[1], date.split('-')[2])
    paragraph_5 = doc.add_paragraph()
    paragraph_5.add_run(word_7)
    paragraph_5.add_run(sign_date).underline = True
    paragraph_5.alignment = WD_PARAGRAPH_ALIGNMENT.RIGHT

    for paragraph in doc.paragraphs:
        for run in paragraph.runs:
            # 统一修改颜色
            run.font.color.rgb = RGBColor(0, 0, 0)
            run.font.name = '楷体'
            r = run._element.rPr.rFonts
            r.set(qn('w:eastAsia'), '楷体')
    doc.save(path + "\{}-请假条.docx".format(name))

workbook = load_workbook(path + r'\Leave.xlsx')
sheet = workbook.active
n = 0
for row in sheet.rows:
    if n:
        name = row[0].value
        department = row[1].value
        reason = row[2].value
        days = row[3].value
        date = row[4].value
        request_for_leave(name, department, reason, days, date)
    n += 1

四、总结

load_workbook：加载excel文件

sheet.rows：所有行的迭代对象

add_heading：添加标题

add_paragraph：添加段落

add_run：在段落后面添加文字

paragraph_1.alignment = WD_PARAGRAPH_ALIGNMENT.CENTER：居中