Python script to take rows of an Excel file and put them into a Word Document, by page.

xlsx2doc.py

import openpyxl
from docx import Document

def stupid_tax(x):
    try:
        x = x.split('.')[0]
        return x
    except:
        return x

f = Document()
x = input("What is the filename? (must be .xlsx type): ")
h = input("To what column letter would you like to export?: ")
wb = openpyxl.load_workbook(stupid_tax(x)+'.xlsx')
sheet = wb.get_sheet_by_name('Sheet1')
end = str(h)+str(sheet.max_row)
print(end)
for rowOfCellObjects in sheet['A1':end]:
    for cellObj in rowOfCellObjects:
        f.add_paragraph(str(cellObj.value))
        loc = (str(cellObj).split('.'))
        if loc[1][0] == str(h[0]):
            f.add_page_break()

print("Write successful.\n")
x = input("Name for export?: ")
f.save(stupid_tax(x)+'.docx')