Hi, as title says i tried to import data from an excel table to and word table template and after multiple tries i got stuck and don't know what else to do.
But i tried like this and is working, but i dont want to write all the lines from the excel manualy.
from mailmerge import MailMerge from openpyxl import load_workbook from docxtpl import DocxTemplate, RichText, InlineImage from docx.shared import Inches, Mm wb = load_workbook('Site1.xlsx') sheet = wb['Sheet1'] max_col = sheet.max_row sheet.delete_rows(sheet.min_row, 1) for i in range (1, max_col): template = 'MOP_DenHaag_V1.0.docx' document1 = MailMerge(template) document1.merge(Migration_ID = str(sheet.cell(row = i , column = 3).value), Group_ID = str(sheet.cell(row = i , column = 2).value), Day = str(sheet.cell(row = i, column = 3).value), PEER = str(sheet.cell(row = i, column = 6).value), Port = str(sheet.cell(row = i, column = 7).value), New_Port = str(sheet.cell(row = i, column = 8).value) ) document1.write('excel2word'+str(sheet.cell(row = i, column = 1).value)+'.docx')This method dosen't work it only create 40+ word files.
But i tried like this and is working, but i dont want to write all the lines from the excel manualy.
contexttbl = {} resultLinks = [] allLinks = [] linkDic = {'Migration_ID':1,'Group_ID':"Two",'Day':"one"'','PEER':"Router-PE17",'Port':"ethernet 7/0",'New_Port':'port3'} linkDic2 = {'Migration_ID':2,'Group_ID':"Two",'Day':"one"'','PEER':"Router-PE18",'Port':"ethernet 7/1",'New_Port':'port2'} linkDic3 = {'Migration_ID':3,'Group_ID':"Two",'Day':"one"'','PEER':"Router-PE19",'Port':"ethernet 7/2",'New_Port':'port10'} allLinks.append(linkDic) allLinks.append(linkDic2) allLinks.append(linkDic3) contexttbl['links'] = allLinks # doc.render(contexttbl)