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 :)
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 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.
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.
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 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.
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!
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.
![Automate Excel and Word with Python - Excel Sheet to Word Docs [openpyxl, docxtpl]](http://i.ytimg.com/vi/6A-S91rqBho/mqdefault.jpg)
![Automate Excel and Word with Python - Excel Sheet to Word Docs [openpyxl, docxtpl]](/img/tr.png)
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 :)
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
Would also be interesting to see a good way to create pdf files with python via latex.
What about filling pdf files? Or automated convertion of docx to pdf.
Thanks so much for your sharing. It works really well. This saves my time. Keep up with your good work!
Thank you, master
Great video!
please explain every line in a more easy way for those people who are using such modules first time
Thanks
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.
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.
This is great
thank you, but I think, word has something built-in for this.
wasn't auto fill in template is a built-in feature?
Which OS is this?
can you make a video for controlling/automating power bi dashboards
What if I wanted to fill the file with an LLM generation ?
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.
Ese codigo falla a veces, es muy inestable , no reemplaza muchas veces.
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!
I ve used this at work haha
First comment and this seems like a good video.
Thx_.
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.
Comments on word file
Hero