I try to import data from Excel table to Word Template.

[NewbiePyPy]

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.

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23

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.

1 2 3 4 5 6 7 8 9 10 11 12 13 14

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)