import openpyxl
from docx import Document
import datetime
def isNone(a):
if a == 'None':
return " "
else:
return a
#打开数据文件
file1 = openpyxl.load_workbook('数据.xlsx')
table1 = file1['Sheet1']
#取数据
data0 = list(table1.values)
data0.pop(0)
print(f'共{len(data0)}条数据:')
for num in range(len(data0)):
#打开模板
file = Document(r'审批表.docx')
table1 = file.tables[1]
# 正式修改数据
table1.cell(12, 3).paragraphs[0].runs[0].text = isNone(str((data0[num][2])))
table1.cell(12, 25).paragraphs[0].runs[0].text = isNone(str((data0[num][3])))
table1.cell(13, 3).paragraphs[0].runs[0].text = isNone(str((data0[num][4])))
table1.cell(13, 25).paragraphs[0].runs[0].text = isNone(str((data0[num][5])))
table1.cell(15, 3).paragraphs[0].runs[0].text = isNone(str((data0[num][7])))
table1.cell(15, 25).paragraphs[0].runs[0].text = isNone(str((data0[num][10])))
print(f'{data0[num][11]}--审批表.docx')
# 保存
file.save(f'输出文件/{data0[num][11]}--审批表.docx')
print('输出完成!')
phthon操作文件
最新推荐文章于 2024-07-23 14:36:35 发布