Automate Excel and Word with Python - Excel Sheet to Word Docs [openpyxl, docxtpl]
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
Source code: https://github.com/codefirstio/excel-...
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
*************
*Tags*
Python tutorial
openpyxl
openpyxl tutorial
learn openpyx
Python automation project
docxtpl
Python Resume Project
Python Automation GUI Project
Watch video Automate Excel and Word with Python - Excel Sheet to Word Docs [openpyxl, docxtpl] online without registration, duration hours minute second in high quality. This video was added by user Code First with Hala 27 March 2023, don't forget to share it with your friends and acquaintances, it has been viewed on our site 7,78 once and liked it 27 people.