Python Automation: Excel Sheet to Word Docs with openpyxl and docxtpl
In this tutorial, you will learn how to use Python to automate the process of converting Excel sheets to Word documents. You will use openpyxl and docxtpl libraries to read, write, and format data.
Use an Excel sheet to generate many Word docs. Generate certificates for students based on their data in Excel.
In this video, you will:
- Build a Python automation project
- Install openpyxl
- Install docxtpl
- Load data from Excel with openpyxl
- Use doxtpl to automate Word documents with Python
- Generate Word documents with Python
Timestamps:
00:00 Introduction and demo
01:27 Installing openpyxl and docxtpl
03:26 Reading rows from Excel with openpyxl
05:48 Generate the certificate Word docs with docxtpl
Source code: https://github.com/codefirstio/excel-to-word-docs
