|
def read_excel_file(path):
"""获取源文档内容"""
wb = load_workbook(path)
ws = wb.active
# case = []
num = 0
for row in range(2, ws.max_row + 1):
data = {}
data['Test Case ID'] = ws.cell(row, 3).value
data['Objective'] = ws.cell(row + 6, 2).value
data['Requirements'] = ws.cell(row + 8, 2).value
doc = DocxTemplate(r'C:\Users\q\Desktop\Script\template.docx')
if data['Test Case ID'] is not None and data['Test Case ID'] != "Expected Result": # 字符匹配修改
context = {
"Object": data['Objective'], "testCaseID": data['Test Case ID'],
"SRD": data['Requirements'],
}
print(data)
doc.render(context)
num = num + 1
print(num)
doc.save(r'C:\Users\q\Desktop\Script\template222.docx')
|
|