Automatically Fill Word Files with Python

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

[@samrijijkot]

Would also be interesting to see a good way to create pdf files with python via latex.

[@StYxXx]

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

[@MrRichy124]

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.

[@MrMKA2012]

do you think this could be way to create program that may help accountant to make his life easier?

[@MrRichy124]

@@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.

[@MrMKA2012]

Well that is great, now will consider invest time in learning this , Thank you for telling your experience.@@MrRichy124

[@EdwardTilley]

Great video!

[@serychristianrenaud]

Thanks

[@saadzahem]

What about filling pdf files? Or automated convertion of docx to pdf.

[@vasukansal1834]

please explain every line in a more easy way for those people who are using such modules first time

[@vishnubalaji9500]

can you make a video for controlling/automating power bi dashboards

[@jvsonyt]

This is great

[@jackbauer322]

What if I wanted to fill the file with an LLM generation ?

[@muhammedhijazi4080]

Which OS is this?

[@TheOneHong]

wasn't auto fill in template is a built-in feature?

[@JonesDawg]

I ve used this at work haha

[@Sebwazhere]

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.

[@philtoa334]

Thx_.

[@paulinepanganiban7938]

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!

[@ExcelInstructor]

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?

[@jwilliams7471]

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.

[@iaconst4.0]

Ese codigo falla a veces, es muy inestable , no reemplaza muchas veces.

[@mrbusiness8648]

Hero

[@PANDURANG99]

Comments on word file

[@Biokompott]

thank you, but I think, word has something built-in for this.

[@redcraft612]

First comment and this seems like a good video.

[@r00tey545]

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'

[@frederikjonssonmadsen6530]

I get the same error!

[@frederikjonssonmadsen6530]

However, I found out that the error appeared because of the fact that the document was open when I ran the code.