資源簡介
windows下,使用python 將Excel中數據批量導出到Word模板中生成新的文件
代碼片段和文件信息
from?tkinter?import?*
from?tkinter?import?filedialog
import?tkinter.messagebox
import?csv
from?docxtpl?import?DocxTemplate
#選取模板
def?seltpl():
????tplpath?=?filedialog.askopenfilename()
????label[‘text‘]?=?‘4.已選擇模板請選擇數據源CSV‘
????docxpath[‘text‘]?=?tplpath
#讀取CVS文件絕對路徑后保存數據到df中
def?load():
????filepath?=?filedialog.askopenfilename()
????with?open(filepath‘r‘encoding=‘gbk‘)?as?f:
????????reader?=?csv.DictReader(fdialect=‘excel‘)
????????for?row?in?reader:
????????????#創建完整替換context字典
????????????for?entry?in?entries:
????????????????context[entry.get()]?=?row[entry.get()]
????????????outputpath?=?‘output/‘+row[‘Name‘]+‘.docx‘
????????????#?替換模板
????????????tpl?=?DocxTemplate(docxpath[‘text‘])
????????????tpl.render(context)
????????????tpl.save(outputpath)
?
- 上一篇:Python極簡教程
- 下一篇:Python實現批量輸入ID查詢成績
評論
共有 條評論