Automatically Fill Word Files with Python
ฝัง
- เผยแพร่เมื่อ 20 ต.ค. 2023
- Today we learn how to automate the filling of word files with Python.
◾◾◾◾◾◾◾◾◾◾◾◾◾◾◾◾◾
📚 Programming Books & Merch 📚
🐍 The Python Bible Book: www.neuralnine.com/books/
💻 The Algorithm Bible Book: www.neuralnine.com/books/
👕 Programming Merch: www.neuralnine.com/shop
💼 Services 💼
💻 Freelancing & Tutoring: www.neuralnine.com/services
🌐 Social Media & Contact 🌐
📱 Website: www.neuralnine.com/
📷 Instagram: / neuralnine
🐦 Twitter: / neuralnine
🤵 LinkedIn: / neuralnine
📁 GitHub: github.com/NeuralNine
🎙 Discord: / discord - วิทยาศาสตร์และเทคโนโลยี
Great video!
I did something like this without extra packaged once in javascript. Just reading the file. You have to make sure the placeholders aren't splitted (which can happen in doc files, there can be tags within a word - you can edit the template though), but besides that it's a pretty forward string replacement.
This solutions seems to be way more easier though :)
Would also be interesting to see a good way to create pdf files with python via latex.
This is great
I did create something exactly like this with some additional features. I have been using replace instead of runs but sometimes that indeed leads to formatting issues. I used this to create 83 documents at once which is very valueable. Sometimes the date formatting in excel is an issue but that can be solved by converting it to text. With your csv approach that isn't an issue although for a user xlsx shows a better overview. Mine also automatically detects the headers instead of hardcoding them.
do you think this could be way to create program that may help accountant to make his life easier?
@@MrMKA2012 yes we have been using this at my firm. If you have some word document that needs to be created semiregularly it is worth the time. The word templates need some work put in them, but overall this saved around 26 hours of work. Prospectively more once used more. The tool is universal. I created a column in the excel input with the template names so that it fills several templates from one row iteratively.
Well that is great, now will consider invest time in learning this , Thank you for telling your experience.@@MrRichy124
Thanks
What about filling pdf files? Or automated convertion of docx to pdf.
Which OS is this?
I ve used this at work haha
please explain every line in a more easy way for those people who are using such modules first time
Thx_.
wasn't auto fill in template is a built-in feature?
interesting! thanks for this. new subscriber here! can you create content on creating python script to display computer name, cpuinfo , including users and their associated groups as well as status of services being run in the linux machine? :) Thanks!
can you make a video for controlling/automating power bi dashboards
What if I wanted to fill the file with an LLM generation ?
Hero
First comment and this seems like a good video.
I broke python by deleting a folder, I reinstalled it and nothing I do works, the folder I deleted was something like mingw/mingw62/lib/python 3.10 and now none of my python installations work and I just get the error: No module named 'encodings' when I try to run python.
who knows how we can make a loops in the templates. for example i have a list of orders for each customer and in the template i want to loop through the list of orders and add each order to the file, and each customer has different list length so i want to make loop to make it more dynamic.
i mean i want the loop to be within the template not in the code.
Hello,
Im just trying to start with python,
I have question:
what is that environment your coding in?
Can you go thru code like in VBA when you can execute line by line with f8?
I'll let the author say for certain which editor he is using. However, it looks like JetBrains PyCharm IDE to me. Another highly used IDE is MS Visual Studio Code. Either should work for you.
Ese codigo falla a veces, es muy inestable , no reemplaza muchas veces.
Comments on word file
thank you, but I think, word has something built-in for this.
Sadly getting the error - in terminal:
raise PackageNotFoundError("Package not found at '%s'" % pkg_file)
docx.opc.exceptions.PackageNotFoundError: Package not found at 'template1.docx'
I get the same error!
However, I found out that the error appeared because of the fact that the document was open when I ran the code.