test.docx
成绩通知书
{{name}}的家长，你好：
{{class}}的{{name}}在本次测验中数学成绩为{{math}},英语成绩为{{english}}
假期愉快！
test.xlsx
| name | classs | math | english |
|---|
| A | 一班 | 2 | 3 |
| B | 二班 | 5 | 6 |
Python代码
from docxtpl import DocxTemplate
import pandas as pd
import os
zpath=os.getcwd().replace('\','/')+'/'
file_path=zpath+'通知单合集'
autho=pd.read_excel(zpath+'test.xlsx')
name=autho["name"]
classs=autho['classs']
math=autho['math']
english=autho['english']
num = autho.shape[0]
for i in range(num):
context = {
"name":name[i],
"classs":classs[i],
"math":math[i],
"english":english[i]
}
tpl=DocxTemplate(zpath+'test.docx')
tpl.render(context)
tpl.save(file_path+"{}.docx".format(name[i]))
