from docxtpl import DocxTemplate
from openpyxl import load_workbook
import os
def replace(obj):
if obj is None:
obj = ''
return obj
wb = load_workbook('C:\\Users\\XXX\\Desktop\\August.xlsx') #需要填入Word的Excel工作簿的地址
ws = wb['Topline S&P'] #工作簿中表格的名称,ws表示工作表
contexts = []
data=tuple(ws)
for i in range(29):
for j in range(16):
a1 = ws[data[28][7]].value
a2 = ws[data[28][14]].value
context = {"a1": a1, "a2": a2} #变量名称与Word文档中的占位符要一一对应
contexts.append(context)
contexts
aa
# 创建要保存的文件夹
os.mkdir("C:\\Users\\XXX\\Desktop\\Report")
for context in contexts:
print(context)
tpl = DocxTemplate('C:\\Users\\XXX\\Desktop\\Monthly Report_Issue 94_20210827.docx') #需要填入的Word文档的的地址
tpl.render(context)
tpl.save("C:\\Users\\XXX\\Desktop\\Report.docx")
报错:File "D:\Download\lib\site-packages\openpyxl\utils\cell.py", line 133, in range_boundaries
m = ABSOLUTE_RE.match(range_string)
TypeError: expected string or bytes-like object
代码22、23行是啥?