from openpyxl import load_workbook
from docx import Document
def info_update(doc, old_info, new_info):
for para in doc.paragraphs:
for run in para.runs:
run.text = run.text.replace(old_info, new_info)
for table in doc.tables:
for row in table.rows:
for cell in row.cells:
cell.text = cell.text.replace(old_info, new_info)
wb = load_workbook("C:\Users\guifen\OneDrive\桌面\系统应用\python\python的资源\合同信息1.xlsx")
ws = wb.active
for row in range(2, ws.max_row + 1):
doc = Document("C:\Users\guifen\OneDrive\桌面\系统应用\python\python的资源\合同模板.docx")
for col in range(1, ws.max_column + 1):
old_info = str(ws.cell(row=1, column=col).value)
new_info = str(ws.cell(row=row, column=col).value)
info_update(doc, old_info, new_info)
com_name = str(ws.cell(row=row, column=2).value)
doc.save(f'"C:\Users\guifen\OneDrive\桌面\系统应用\python\python的资源\合同文件\{com_name}合同.docx')