How to Automate Word Documents from Excel CSV Using Python
Using docxtpl to create word/docx files based on a template docx file.
Python then creates new word/docx files, inserting data, where there is a match between the template and the CSV.
One Docx per row in the CSV.
I show an example with 6 rows in the CSV, making 6 Docx files, each file has unique content from the CSV.
After a request from a subscriber, I have now added the code to make the filenames based upon values form the CSV.
Modify the numerical filenames system from 1,2,3,4 etc... enumerated sequence to values from 'title' column.
⚪ My subscriber actually sent me the solution before I had chance to work on this, so credit due to suhas g for the following solution:
✅ Using pandas dataframe, df.loc, it is fairly trivial, just select the row/column with [:, 'title']
This is something I didn't add initially as there was a requirement to manually rename the files once I had raised a change reference in another laborious system!
--------------------------------------------------------------------
If you need a good proxy, I can recommend this one 👍👍👍
🌏 https://www.scraperapi.com?fpr=ken49
Coupon Code: DRPI10
-------------------------------------------------------------------
Credit : Eric Lapouyade https://docxtpl.readthedocs.io/en/lat... #docxtpl
Dr Pi
GitHub Code : https://github.com/RGGH/pydoc
☕️☕️☕️ Buy Dr Pi a Coffee...or Tea! : https://www.buymeacoffee.com/DrPi ☕️☕️☕️
On this page of the site you can watch the video online How to Automate Word Documents from Excel CSV Using Python with a duration of hours minute second in good quality, which was uploaded by the user jobstr 29 June 2020, share the link with friends and acquaintances, this video has already been watched 691 times on youtube and it was liked by 11 viewers. Enjoy your viewing!
