from docxtpl import DocxTemplateimport pandas as pdimport os# 用Python新建文件夹用来存放入学通知书，如果文件夹已存在代码会跳过这一步zpath = os.getcwd() + '\\' #获取当前的路径zpath = r'F:\Python-项目' + '\\'file_path = zpath + r'通知书合集'try:os.mkdir(file_path) #创建一级目录except:pass# print(file_path)# 读取csv文件中的数据data = pd.read_csv(zpath+'学生数据.csv', encoding='gbk') #读取csv里的目标数据name = data["房号"].str.rstrip() # str.rstrip()用于去掉空白academy = data["物业费"].values# major = data["专业"].str.rstrip()# 将数据写入模板tpl = DocxTemplate(zpath+'缴费通知单本.docx')# 选定模板num = data.shape[0] # 获取数据行数for i in range(int(num/2)):context = {"a": name[i*2],"b": academy[i*2],# "c": major[i*2],"d": name[i*2+1],"e": academy[i*2+1],# "f": major[i*2+1]}tpl.render(context)#渲染替换tpl.save(file_path+r"\{}的入学通知书.docx".format(name[i*2]))print(zpath+'缴费通知单 - 副本.docx')
