docx-mailmerge | Mail merge for Office Open XML

document.merge_rows('col1',
                    [{'col1': 'Row 1, Column 1', 'col2': 'Row 1 Column 1'},
                     {'col1': 'Row 2, Column 1', 'col2': 'Row 2 Column 1'},
                     {'col1': 'Row 3, Column 1', 'col2': 'R

document.merge(**mydict)

def foo_kwargs(a=1, b=2, c=3):
    print(f'a={a} b={b} c={c}')

my_dict = {'a': 100, 'b': 200, 'c': 300}
foo_kwargs(**my_dict)
# Prints a=100 b=200 c=300

mylist = [

import datetime as dt

...

for i in range(1, max_col):

    # Convert the format here
    Date = str(sheet.cell(row = i, column =4 ).value) # Assuming format e.g. 2020-05-01
    date1 = dt.datetime.strptime(Date, '%Y-%m-%d').strftime('%d-

#here is set new columns names, so original headers are shift to first row of data
df = pd.read_csv('test1.csv',
header=None,
names = headers,
#dtype = dtypes,
#parse_dates = pdate, 
date_parser=None) 

top = df.head()
print(top)
         

values = delimeted_text[1:]
header = delimeted_text[0]
my_Dict = ([{head:val for head, val in zip(header, val)} for val in values])

document.merge_templates(big_Dict, 'nextPage_section')
document.write('J:\output.d

import sqlite3
conn = sqlite3.connect('sqlite_file')
c = conn.cursor()

# Create a table
c.execute('CREATE TABLE {tn} ({nf} {ft})'\
    .format(tn='my_table', nf='name', ft='VARCHAR'))

conn.commit()
# insert table
c.execute("INSERT INTO {