Automate Excel and Word with Python – Excel Sheet to Word Docs

Python is a versatile programming language that can be used for a wide range of tasks, including automating tasks in Excel and Word. In this article, we will be focusing on how to automate the process of converting data from an Excel sheet to a Word document using the openpyxl and docxtpl libraries.

Prerequisites

Before we get started, you will need to have Python installed on your computer. You can download Python from the official website and follow the installation instructions there. Additionally, you will need to install the openpyxl and docxtpl libraries. You can install these libraries using pip by running the following commands in your terminal:

pip install openpyxl
pip install docxtpl

Conversion Process

Now that we have our libraries installed, we can begin the process of converting data from an Excel sheet to a Word document. First, we will use the openpyxl library to read data from an Excel sheet. Here is a simple code snippet that demonstrates how to do this:

import openpyxl

wb = openpyxl.load_workbook('example.xlsx')
sheet = wb.active

for row in sheet.iter_rows(values_only=True):
    for cell in row:
        print(cell.value)

Next, we will use the docxtpl library to create a template for our Word document. This template will allow us to insert data from our Excel sheet into specific placeholders within the Word document. Here is an example of a simple Word template:

Dear ${name},

We are pleased to inform you that your balance is ${balance}.

Sincerely,
Your Company

Finally, we will combine the data from our Excel sheet with the template we created in Word. The following code snippet demonstrates how to do this:

from docxtpl import DocxTemplate

doc = DocxTemplate("template.docx")

data = {
    'name': 'John Doe',
    'balance': 1000
}

doc.render(data)
doc.save("output.docx")

By following these steps, you can automate the process of converting data from an Excel sheet to a Word document using Python. This is just one example of how Python can be used to streamline tasks and make your workflow more efficient.