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: 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

[@bigrevkev55]

Thank you so much! I'm a college registrar and the company that stores and prints our diplomas was just bought out by a bigger company which has jacked up the annual subscription. So I've created our own. I use a database connection instead of a excel file but it works the same!

[@ontenzen3284]

Cool tutorial. I haven't tried it myself, but I will definetly come back to this, when I have a similar use case. Keep up the good work.

[@lega1985]

Спасибо!!! Ты лучшая! Если б мог, то расцеловал!!! Все объяснила очень просто и наглядно!!! ❤❤❤

[@fabriciocarranza7044]

Amazing. Thank you

[@lajonas3628]

Hi Hala, i apricate your effort,.. thank you for the video

[@ibrahimmoawadibrahim7332]

Great 📃

[@naveenkarthik3305]

Awesome ❤. You are the best Hala.

[@asianpsalmshymns]

Outstanding Explanation Respectable Madam❤

[@christianmller7330]

Great video! Is there a way to do the same thing but with tables from excel?

[@sayurijurema]

I am beginner in python, and this video is really easy to understand. But i would like to generate all the certificates as 1 file.docx, how can i change it?

[@turtlecode]

Perfect tutorial, thanks

[@Abcs-o7j]

How one can extract data like (mp2 = -3.2424) from a large txt file using python programme.??? Please instruct me

[@BriNgHouZ]

Thanks for the video. How can I make same but for an excel template? Didnt manage to reach the same result with xlwings

[@tarasgolovatyj4369]

holllyy. I'm so exited to find this way of doing stuff. Thanks so mush. As all that "Microsoft out of a box office ways" makes me feel too stupid

[@alielsheikh8091]

Hello, how can I make my python PyQT5 app with a button to check for updates and deploy my updates remotely online ?

[@nict5683]

Hey Hala - this was awesome. I am on to the next step of difficulty here - i have multiple rows of data that i need to combine in a single output. The rows will have a common identifier in tuple[0]. 90% of the data in both rows match, but i need a way to pull the unique values from the 10% of columns to the single docx output. Any advice?

[@tarasgolovatyj4369]

Hey, why not just to re-make data? Get raw from exel than use some work around to have needed list or dict and use it as you need?

[@sanathkumarr9075]

Its not Looping over generating documents with different data in my case.... Need help

[@RadovanPalik]

You should switch from Python to R and C#. You'll find the world will be nicer and the code faster.