Automating Word Documents from Excel Using Python | ‘docxtpl’ Tutorial

👉 Explore All My Excel Solutions: pythonandvba.com/solutions
𝗗𝗘𝗦𝗖𝗥𝗜𝗣𝗧𝗜𝗢𝗡
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
Did you know you can use Python code to dynamically create Word Documents? For this tutorial, we will be using the Python libraries ‘xlwings’ & ‘docxtpl’ to automate Word. In particular, we will be writing values from Excel to Word by using Python.
Download all the files from the tutorial:
👉 GitHub: github.com/Sven-Bo/python-wor...
𝗧𝗢𝗢𝗟𝗦 𝗔𝗡𝗗 𝗥𝗘𝗦𝗢𝗨𝗥𝗖𝗘𝗦
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
🆓【𝗙𝗥𝗘𝗘】Excel Add-in (𝗠𝘆𝗧𝗼𝗼𝗹𝗕𝗲𝗹𝘁): pythonandvba.com/mytoolbelt
📊 Dashboard Excel Add-In (𝗚𝗿𝗮𝗳𝗹𝘆): pythonandvba.com/grafly
🎨 Cartoon Charts Excel Add-In (𝗖𝘂𝘁𝗲𝗣𝗹𝗼𝘁𝘀): pythonandvba.com/cuteplots
🤪 Fun Emoji Excel Add-In (𝗘𝗺𝗼𝗷𝗶𝗳𝘆): pythonandvba.com/emojify
📑 Excel Templates: pythonandvba.com/go/excel-tem...
🎓 My Courses: pythonandvba.com/go/courses
📚 Books, Tools, and More: pythonandvba.com/resources
𝗖𝗢𝗡𝗡𝗘𝗖𝗧 𝗪𝗜𝗧𝗛 𝗠𝗘
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
🔗 LinkedIn: / sven-bosau
📸 Instagram: / codingisfun_official
💻 GitHub: github.com/Sven-Bo
💬 Discord: pythonandvba.com/discord
📬 Contact: pythonandvba.com/contact
☕ 𝗕𝘂𝘆 𝗺𝗲 𝗮 𝗰𝗼𝗳𝗳𝗲𝗲?
If you want to support this channel, you can buy me a coffee here: pythonandvba.com/coffee-donation

[@elsheep6951]

Clear and concise. Delivers results and contains plenty of explanation to enable the viewer to adapt to their own project. Thank you for an excellent tutorial.

[@CodingIsFun]

Thank you very much for your generous feedback & the kind words! I am glad you enjoyed it! ❤

[@corentindurand6283]

Very good, as usual ! I just love the fact that you don't need to be a profesionnal programmer to follow your tutorials. Really accessible with a basic knowledge.

[@CodingIsFun]

Thank you very much! Glad to hear that the tutorials are easy to follow 😃

[@erickgutierrez6471]

Dude , since i started watch your videos , my desire to learn python has grown.Thanks!

[@CodingIsFun]

That's awesome to hear! Thank you for taking the time to leave a comment and for watching the videos! 😃

[@florianroeseler2404]

Didn’t know I needed this until now!

[@CodingIsFun]

Thank you for watching the video, Florian. Glad you like it! 😃

[@falcon2806]

Again a very good tutorial ... thanks Sven

[@CodingIsFun]

Thank you for your support, Falcon. Glad you like it 😃

[@rty3997]

Thank you very much Sir! Your tutorial are very helpful and matched well with my work environment. Subscribed.

[@CodingIsFun]

Thanks for the sub and welcome aboard! :)

[@rodrigoarturoborjacalderon5913]

AMAZING! keep doing your best :D

[@CodingIsFun]

Thanks! Glad you like the solution :)

[@risshirajsen8347]

Thank you so much , i could easily follow along the tutorial and help automate a tidious task my father has to do eveytime.

[@CodingIsFun]

That is awesome! Fantastic to hear that :)

[@KhalilYasser]

Awesome. Thank you very much.

[@CodingIsFun]

As always, thank you very much for your comment & support 😃

[@victorsartor]

Your video solved half of my problems! Now I need to think of a way to convert the data from the excel file to a word file whenever a new entry is added to the excel file. I thought about using python-docx, but I would need to make the template ready for all possible entries in my csv file. Gosh I have no idea how to proceed lol Thanks for your work!!!!

[@CodingIsFun]

Thanks for watching the video and good luck with your project! Happy Coding! 🤓

[@shrushtiamulya5553]

Very Informative Thanks

[@CodingIsFun]

Glad it was helpful! Thanks for watching :)

[@cryptomugen1315]

Wow, exactly what I was looking for. It's straight to the point and easy to understand. Can you show how we would have a dynamic sentence based on the number we import from Excel? e.g. Sales on {{this period}} was {{sales}} which is {{more/less}} than {{prev period}} for {{an increase/a decrease}} of {{sales/prev sales-1}}%.

[@CodingIsFun]

Thanks for watching the video. Glad it was helpful. There are 2 approaches: a) You could simply concatenate your string directly in Excel and export it as only *one* variable, e.g. ="Sales on "&A1&" was "&A2&" which is "&IF(A2>B2,"more", "less")& " than….." b) Use the Jinja2 Tags in your Word documents: docxtpl.readthedocs.io/en/latest/#split-and-merge-text Hope it helps 😃

[@walidmat8972]

amazing video 🔥

[@CodingIsFun]

Thank you!

[@pilotgundul]

Wow.. this is amazing.. Thanks for the tutorial

[@CodingIsFun]

Glad to hear you liked it! Thank you for commenting and watching.

[@pilotgundul]

@@CodingIsFun I have no idea on python before but I think it is easy to learn ;) may be

[@ElinLiu0823]

much thanks,this touraial gonna help me,like!🥰

[@CodingIsFun]

Thanks for watching the video. Glad to hear it was helpful! :)

[@darshan511]

@coding is fun thank you for the wonderful tutorial it was so helpful to me..

[@CodingIsFun]

Happy to hear that it was helpful; thank you for taking the time to leave a comment and for watching the video! 👍

[@sheikhraisulislam4483]

well made tutorial sir

[@CodingIsFun]

Happy to hear that it was useful; thank you for taking the time to leave a comment and for watching the video!

[@musicalharmony1402]

Hello, this is an amazing video . Very insightful and very useful. I was wondering if you could also give some ideas on how to create a PowerPoint using a similar dictionary rendering format? I have checked python-pptx but there we do not have the freedom to place the values in the placeholders. There we have fixed shapes and only they can be used.

[@CodingIsFun]

Thank you for watching the video and for your question. Unfortunately, I do not know how to implement that right off the bat. I would also need to search the internet for a solution. Sorry that I cannot help!

[@cindyb9606]

Thank you again for your very helpful tutorial. I wanted tocomment that I was having difficulty getting the images to show up in MS Word. In case anyone else is also not getting the images to show up, I had to add the name of my placeholder value to the Alt Text parameter for that particular picture in the MS Word Template. Just go to the image placeholder picture in MS Word and right click on it to open the expanded menu, click on the option 'Edit Alt Text' and type in the image placeholder name (like Placeholder_A.png) - then exit the sidebar by clicking the 'X' Do NOT click on the button 'Generate alt text for me' -- it will do that with your tag when you close the menu.

[@CodingIsFun]

Thanks for watching and your additional hint! 👍

[@jaggyjut]

Nice. What if we have checkboxes and option buttons in the word template. I have a table in the word doc with yes/no and want to hide/show the value as per the value in the Excel column

[@CodingIsFun]

Thank you for watching the video and for your question. Unfortunately, I do not know how to implement that right off the bat. I would also need to search the internet for a solution. Sorry that I cannot help!

[@coen690]

Thanks for the great tutorial. I am actually trying to create a very similar system. I have a question regarding the the line: import xlwings as xw and the line: from docxtpl import DocxTemplate. I get the errors Import "xlwings" could not be resolved and Import "docxtpl" could not be resolved. I checked and both libraries are installed. Do you have an idea what might be going wrong in this case? I used exactly the same code as in your video. I am using a mac though.

[@CodingIsFun]

Thanks for watching. Both libraries will also work on mac. That said, it is hard to tell what might be causing the error from a distance. My best guess is that you are executing the code from a different environment (in which you do not have the libraries installed).

[@nipzw]

Great video! :) Also, I'm looking into based on a specific field/values from the Excel sheet, how to modify/set the values of radio buttons (to Yes/No) in the Word document?

[@CodingIsFun]

Thank you for watching the video and for your question. Unfortunately, I do not know how to implement that right off the bat. I would also need to search the internet for a solution. Sorry that I cannot help!

[@williammendieta5427]

Thanks! You can do this Word document automation using VBA too... its just not as easy as it is using Python!

[@CodingIsFun]

Thank you for watching the video. True - with VBA, you could do the same. Yet I also like the fact that Python makes it very easy 👍

[@fatoumatasissako2140]

Hello, thank you very much for your very useful video. I would like to reproduce the same thing but instead of generating all the pdfs at the same time I want the word file to be created on demand. For example, I want to have a drop-down list that will allow me to select a client and then the code will generate its word file with its information. The drop-down list can be on Excel or on another interface. Do you have any ideas on how to do this please?

[@CodingIsFun]

Thanks for watching the video. In the video, I am actually creating only one file. In your case, you just might want to insert a DropDown list in Excel (www.excel-easy.com/examples/drop-down-list.html). Based on the selected values from the DropDown, you can then change the variables using Excel formulas, e.g. =IF(A1="Client A", "If true show this value", "…otherwise show this value") I hope this helps!

[@JITISH1]

Hi, extremely helpful tutorial. How does one go about doing this if the table has multiple columns? Eg Parameter | Start | Average | Failure| Where Start, Average, and failure have values, and the parameter is the actual "product name" in this case. The table in my word document is structured in the same way. Also, there are multiple tables on my first sheet. Thank you for your assistance with this tutorial. When working in the xlwings Excel file, the excel file closes as soon as I click the button.

[@CodingIsFun]

Thank you very much for watching the video and your comment. Your requirements are well noted. Yet, I receive many requests for creating individual solutions. As much as I want to help, I simply do not find the time in my daily schedule to develop & test all the different requests. I hope you can understand. Thank you!

[@wadspo7155]

Very interesting... I am trying to figure out how to automate a word document/pdf upon email receipt, as well as have that newly created word document/pdf emailed after creation.

[@CodingIsFun]

Thanks so much for watching the video and leaving a comment! Your request is definitely noted. However, I get a ton of requests for custom solutions and, as much as I'd love to help everyone out, I just don't have the time in my schedule to develop and test all of them. I hope you can understand. Happy Coding!

[@ajalikhanz]

Great video! If I wanted to implement this on someone else's laptop after I've done this on mine, would I have to do all this again? Or would I just have to send them all the files we have created here?

[@CodingIsFun]

Thanks for watching the video. Assuming that the receiver also has Python, then you only need to send them the files.

[@Paper4Wings]

Thanks a lot! Some trial and error as a new Python user, but got there in the end.

[@CodingIsFun]

Glad you figured it out! :)

[@Paper4Wings]

@@CodingIsFun Hey! It worked for a while but I'm now getting a "sh: python: command not found " error. Can you help?

[@CodingIsFun]

@@Paper4Wings Sounds to me more like a Python (installation) issue. You might want to search the internet for a solution.

[@Paper4Wings]

@@CodingIsFun turns out my Python was out of date, thanks!

[@dbiviss]

Do you know how can you work with tables dynamically ? Just without knowing the size of rows in the template and only in the excel file. Thank you!

[@CodingIsFun]

Here is an example: github.com/elapouya/python-docx-template/blob/master/tests/dynamic_table.py The script is referring to this Word document: github.com/elapouya/python-docx-template/blob/master/tests/templates/dynamic_table_tpl.docx Screenshot: www.screencast.com/t/SyN9abVBr8E

[@rajasingam.d]

This work very nicely. But if we have input data in C column. i mean need multiple doc for the data. How this can be achieved. Do you have any reference. Using for i need to automate more than 2 records. Can you please help me on this. Input data is in B column, i have B and C column input data. How do we can bring the data in context. Thanks

[@CodingIsFun]

Thank you very much for watching the video and your comment. Your requirements are well noted. Yet, I receive many requests for creating individual solutions. As much as I want to help, I simply do not find the time in my daily schedule to develop & test all the different requests. I hope you can understand. Thank you!

[@privateusername2222]

I need to use word's field programming to modify the text of the word document based on excel values. Any suggestion how to do this with your excel method? Ive used text input boxes in my word doc and no excel all along. Thank you.

[@CodingIsFun]

Thanks so much for watching the video and leaving a comment! Your request is definitely noted. However, I get a ton of requests for custom solutions and, as much as I'd love to help everyone out, I just don't have the time in my schedule to develop and test all of them. I hope you can understand. Happy Coding!

[@rishanchaube3098]

Absolutely loved your video!!! Just one thing I need to know. When declaring the context dictionary, is there some way I can store the numbers in the same type as given in excel? Example: 1) if I use numbers=int while declaring the context dictionary, I can't work with specific values needing decimal precision (For example, mass of an electron). So how can I make python insert the exact same number as in excel?

[@CodingIsFun]

Thank you for watching! If you'd like to obtain the original value without modifying it, you can simply remove the "numbers" parameter from the options method. Refer to the xlwings dictionary converter documentation for more information on available options: docs.xlwings.org/en/latest/converters.html#dictionary-converter

[@elpp2937]

Is it possible to combine and compare more than ten documents and then merge them into one with amendments being marked in revision mode? Thank you.

[@CodingIsFun]

Questions are great, but I would also need to search the internet for an answer. I would suggest starting by comparing only 2 files using the win32com library: stackoverflow.com/questions/47212459/automating-comparison-of-word-documents-using-python Once that is working, you can try to merge multiple files. Sorry that I cannot help you further here. Happy Coding!

[@bojandanon2037]

I have big table with same data that I would like to put into template, is it possible to select certain range of cells in big table and than press button to put selected data into template ?

[@CodingIsFun]

Thank you very much for watching the video and your comment. Your requirements are well noted. Yet, I receive many requests for creating individual solutions. As much as I want to help, I simply do not find the time in my daily schedule to develop & test all the different requests. I hope you can understand. Thank you!

[@josea.bocanegra6774]

Muchas gracias , espectacular , muy agradecido, deseaaba consulta que contiene la macro Samplecall

[@CodingIsFun]

Thanks for watching! Cheers, Sven 🙏

[@walterruelas6064]

Hi again Sven, how can we get or create more placeholders images? cause we only have five in the folder you shared with us.

[@CodingIsFun]

You can insert as many images as you want as showed in the video.

[@zouhairsouam6709]

This is very helpful, i would like to thank you. Please could you make another video on how to make a python script that draw a netwrok architecture or a network diagram and generate a visio file ? thank you.

[@CodingIsFun]

Thank you for watching the video & your suggestion.

[@rodfreitas1935]

Hi, Sven Excellent video! Congratulations Quick Question: Is there any possibility to update the table of contents using python docx?

[@CodingIsFun]

Thank you for watching the video and for your question. Unfortunately, I do not know how to implement that right off the bat. I would also need to search the internet for a solution. Sorry that I cannot help!

[@walterruelas6064]

Thanks so much Sven for the amazing video, please could you make a video to automate pptx documents, I think theres is a library pptxtpl. Thanks so much for your effort.

[@CodingIsFun]

Thank you for watching the video & your suggestion.

[@HabibKhan-kj8um]

Thanks for the video. Quick question though, what if you have a dataframe and you want to generate multiple docs (same format)? Can we loop through the function you created and in each loop take one rows and create one doc?

[@CodingIsFun]

Have a look at the following video: kzbin.info/www/bejne/kKqcpKtqfNudi7s I hope it helps! Happy Automating! :)

[@HabibKhan-kj8um]

@@CodingIsFun That's awesome. Thank you very much

[@kirankrisnan]

Awesome video. I'm a big fan of your videos :) I was wondering is there any way to edit the values of an existing graph chart in ms word using docxtpl or docx or any other module? Not inserting an image as graph, but to edit/update the values of an existing graph in ms word using python. It will be great if you can come up with a solution. I'm sure it will be useful for many.!

[@CodingIsFun]

Thank you for watching the video and for your question. Unfortunately, I do not know how to implement that right off the bat. I would also need to search the internet for a solution. Sorry that I cannot help!

[@skjchan]

Thank you so much for your tutorial. I followed your tutorial and created my first word document with data from excel successfully. Now I have a list of student name, class and class number to be displayed under the same word documents, say a table of 15 rows x 3 columns, how can I add it to the word template so that python can extract data from the excel table?

[@CodingIsFun]

Thanks for watching. You can extract the Excel table using xlwings: stackoverflow.com/a/36396797 Once you have the data from Excel, you can create a dynamic Word table: Here is an example: github.com/elapouya/python-docx-template/blob/master/tests/dynamic_table.py The script is referring to this Word document: github.com/elapouya/python-docx-template/blob/master/tests/templates/dynamic_table_tpl.docx Screenshot: www.screencast.com/t/SyN9abVBr8E I hope it helps! Happy Coding!

[@byqsxgzh7327]

Very helpful tutorial, excatly what I needed, thanks a lot. But how can I format numbers with comma separators and round to 2 decimal places?

[@CodingIsFun]

Glad you liked the video. You can format numbers with Python. See the example below: my_number = 12345678.1234 my_number = f'{round(my_number,2):,}' print(my_number) Run the code online here: onecompiler.com/python/3xea6y593 I hope this helps!

[@byqsxgzh7327]

@@CodingIsFun Thanks for your reply. I'm a beginner of coding. How can I use this function in this particulaur tutorial? As the info. used to render Word is from "context", and context is dict, I can't use f"{}" to format dict.

[@thefamousdjx]

Nice video. Would have been more useful if you had shown how to fill the table dynamically too. Most other cases one wont know beforehand the number of rows that will be required.

[@CodingIsFun]

Thank for watching the video! Excellent hint! This is actually also possible within the docxtpl, but I did not show it in the video 🙁

[@thefamousdjx]

Okay thanks, looking forward to more advanced video if you do make.

[@user-bt5gt1fy3t]

hello, in one of my application if user order more then one product we have to create same structure of table for each product dynamically and stable structure, style provide user only , we just know filed/label are fix. so any one can guide how we can achieve.

[@CodingIsFun]

Thanks so much for watching the video and leaving a comment! Your request is definitely noted. However, I get a ton of requests for custom solutions and, as much as I'd love to help everyone out, I just don't have the time in my schedule to develop and test all of them. I hope you can understand. Happy Coding!

[@reneoviedo3789]

Thanks so much for the video!!, i was wondering if it is possible to convert all of this files into an .exe so i can run it in different computers that are not using python?

[@CodingIsFun]

Thank you for watching the video. Yes, that is possible. Have a look at the following video: kzbin.info/www/bejne/j2Grf2yqmbGogNE I hope this helps! 👍

[@phunguyenhoang211]

Very useful to me. Thank you so much. Do you have any video/idea about automating copy/paste data from word to excel?

[@CodingIsFun]

Thank you for watching the video & your questions. You might want to check out the following article: theautomatic.net/2019/10/14/how-to-read-word-documents-with-python/ There are different libraries to interact with Word. Once you get the values from the Word Document, you could use xlwings to insert them in Excel. I hope this helps!

[@phunguyenhoang211]

@@CodingIsFun thank you

[@mushtaqtaher]

Hey - When I try to install Docxtpl or python-docx it always says pip command not found on my command prompt - do you know why this is this? Thanks

[@CodingIsFun]

Try: pip3 install python-docx If that does not help, have a look at the following blog article: techlib.fr/app/19847/how-do-i-fix-pip-command-not-found

[@Hex-Scholar]

Hey, how could we add the rendered word file created using docxtpl into an existing word file.

[@CodingIsFun]

Thank you very much for watching the video and your comment. Your requirements are well noted. Yet, I receive many requests for creating individual solutions. As much as I want to help, I simply do not find the time in my daily schedule to develop & test all the different requests. I hope you can understand. Thank you!

[@kilme880]

that's helped me a lot ! where i can find good templates for analysis report ?

[@CodingIsFun]

Thank you for watching the video & your question. I am not sure if those kind of templates exists - sorry 😕 I usually create my own templates as shown in the video.

[@eriktedja1199]

Is It possible to get the data from Multiple Columns and Multiple Rows ? for example Col A : Company Name, Col B : Cities, Col C : Revenue and so on. The Word Document will have 3 paragraph, Each Paragrah will talk about a different company from the above table. After testing this, I've met some problems: Traceback (most recent call last): File "C:\Users\x\Desktop\word_automation\example.py", line 9, in placeholder_1 = InlineImage(doc, 'Placeholders/Placeholder_1.png', Cm(5)) NameError: name 'InlineImage' is not defined

[@CodingIsFun]

Yes, it is possible, but it requires further modification to the code. I hope you understand that I cannot code out a complete example for you. Regarding your error message, ensure that you have InlineImage imported: from docxtpl import DocxTemplate, InlineImage # pip install docxtpl Happy Coding! :)

[@rosha3933]

Can someone help me, after I install "xlwings" and type " xlwings quickstar " it doesn"t work, it says it is not recognized as an intern or external command.

[@CodingIsFun]

Did you install it using 'pip install xlwings'?

[@SaulEduardoo2]

The same happened to me... I'm using the CMD window and tells me that after used the command "pip install xlwings"

[@jhanvivadher257]

Hi, The document is created when I run the Python file. However it doesn't CREATE document when I click the button. I include printing something like 'Bye Xkwings'. So it works. But the document is not created. Please help

[@CodingIsFun]

Thanks for watching and for your question. Hard to tell from a distance why you are facing an error. Sorry that I cannot help. Cheers, Sven ✌️

[@mladenvujic4034]

Instead of integer format, how can I retrieve "source formatting" (###.#, ###>#%, etc.) from the file? in this line of code: context = sht_panel.range("A2").options(dict,expand="table", numbers=int).value Tnx!

[@CodingIsFun]

Thanks for watching. xlwngs will just ensure to read in the datatype correctly (int or float) docs.xlwings.org/en/stable/converters.html. To format your numbers, have a look at the following blog post: queirozf.com/entries/python-number-formatting-examples I hope it helps! Happy Coding!

[@mladenvujic4034]

@@CodingIsFun Thank you, really helpful for formatting! Additional questions:) what would be the easiest way to insert an excel table in Word in the same format? thanks!

[@fernandojavierleon5442]

Hello, how can I put images from a url? I've tried but can't.

[@CodingIsFun]

Try out the following solution: stackoverflow.com/a/24348524

[@enginalkan8493]

hello. thanks for the great video. I downloaded all docs, template and code. I am able to execute python script that successfully generate updated document. However, I am having trouble with executing buttons on excel sheets. When I test button on PANEL sheet, I am getting an error "python was not found". I am wondering if you can comment on how to connect the python script into the excel workbook. thanks in advance,

[@CodingIsFun]

Thanks for watching and for your question. Hard to tell from a distance why you are facing an error. Sorry that I cannot help.

[@hellohello-gx1fp]

Thank you, that's really helpful! I would like to ask If it is possible to convert this python file to exe? I have tried many times by pyinstaller but failed ,it said that no module named [that filename]. Do you know why is that? thx

[@CodingIsFun]

Thanks for watching and for your question. Hard to tell from a distance why you are facing an error. Sorry that I cannot help.

[@jesusrodriguez-ls8nr]

Awesome video! I tried implementing it but for some reason i can only run it from python directly, if it try to run the code through excel macro it always fails on the doc.render(context) line. Can anyone help or point me to where get help for that?

[@CodingIsFun]

Thanks for watching. Please clone the GitHub repo and try again.

[@verma7723]

Thanks a lot for this video.. learn a lot from this. Further, how can we make the number of rows in word file dynamic. For example - if the data in excel file is in 3 rows, word file also should show only 3 rows, and if it is 10 rows in excel, number of rows in word file may get expanded to 10. Any guidance/video/code could be very very useful. Thanks once again.

[@CodingIsFun]

Thank you for watching the video & your question. You can also create dynamic tables. Kindly have a look at the following screenshot: www.screencast.com/t/piwEhsqfwq I have used the code straight from the docx-template GitHub page, which you can find here: github.com/elapouya/python-docx-template/blob/master/tests/dynamic_table.py For your convenience, I have copied the Word Template Files & Python code as shown in the screenshot to my Google Drive for you to download: drive.google.com/file/d/1WUZPXZSmpv3mcIOXOfyjmhymyNOr1ful/view?usp=sharing I hope this helps!

[@verma7723]

@@CodingIsFun thank you so much for being so kind and taking out time for this help. 😊😊

[@harishrajkumar5607]

im having trobule with creating folder in desktop im getting error like xlwings is not regonized please guide me withhow to slove this error

[@CodingIsFun]

Thanks for watching the watching and your question. It is hard to tell from a distance what is causing the error. Try searching for the text of your error message on google/StackOverflow.

[@jeandahlquist]

Stupid question most likely, and I did restart the kernel but I get a syntax error from simply writing xlwings quickstart work_automation --standalone. xlwings is fully installed.

[@CodingIsFun]

Could you paste the error message/tracelog here?

[@sumeetkavathekar3694]

Hi there I am encountering this particular error "Exception has occurred: com_error (-2147221005, 'Invalid class string', None, None) " any suggestion to remove the error?

[@CodingIsFun]

Thanks for watching. Unfortunately, with that bit of information, I cannot help you. You might want to take some time to write down which line of code is causing the error; let me know if you have modified the code from the tutorial, explain in more depth what you did to troubleshoot the problem and provide some more context. Thanks!

[@PerFeldvoss]

... can you generate a word table with data from excel, looks like you will need to use a template with the same names again and again. But how can you do that?

[@CodingIsFun]

Yes, that is possible. Here is an example: github.com/elapouya/python-docx-template/blob/master/tests/dynamic_table.py The script is referring to this Word document: github.com/elapouya/python-docx-template/blob/master/tests/templates/dynamic_table_tpl.docx Screenshot: www.screencast.com/t/SyN9abVBr8E

[@sbalachandran150]

Hi! Many thanks for this wonderful tutorial. Appreciate it. I was able to follow your instructions and design one. It worked. But I have one minor issue. I have a date cell in Excel. I want to populate word with string date for example 1 January, 2022 instead of 1/1/2022. Is there a way out? Thanks once again and have a nice day!😊

[@CodingIsFun]

Thank you very much for watching the video and your comment. Your requirements are well noted. Yet, I receive many requests for creating individual solutions. As much as I want to help, I simply do not find the time in my daily schedule to develop & test all the different requests. I hope you can understand. Thank you

[@rty3997]

How about converting the date value into text first in excel with "=TEXT([YourDateCell],"d mmm yyyy")" ?

[@sbalachandran150]

@@rty3997 Hi!Many thanks for your solution. It worked great.You are a saviour! Thanks again.👍

[@matthewtaylor6284]

For anyone having problems getting your samplecall macro to run, you might need to run the following command in your terminal "xlwings addin install"

[@CodingIsFun]

Thank you for watching and sharing your suggestion! In this situation, the xlwings add-in might not be necessary. Just running the command "xlwings quickstart word_automation --standalone" should be enough. However, I'm glad to hear that installing the additional xlwings add-in was helpful for you.

[@SaulEduardoo2]

I have issues to execute this instruction at the CMD window "xlwings quickstart word-automation --standalone" it tells me that the command "xlwings" is not recognizable as an external command internal and/or external

[@CodingIsFun]

Did you install it using 'pip install xlwings'?

[@SaulEduardoo2]

@@CodingIsFun Yes Sven

[@CodingIsFun]

@@SaulEduardoo2 are you sure that you are calling 'xlwings' from the same environment you installed it in? Please check it with 'pip freeze' in the same command prompt that shows the error

[@feliciak3483]

@@CodingIsFun I'm having the same problem. I've checked it with pip freeze. It's just the addin that wont install. Did anyone having this problem figure out a solution?

[@Diwakarc007]

@codingisfun, Sven - Did we find a solution to this issue?

[@arcticwildernesssurvival680]

Hi, excellent tutorial! I ran into an issue when assigning the sample call macro to the button - Excel runs into an error, that it can't find Python and to download it from the Microsoft store. The excel template comes with some settings options, but I was unable to resolve the issue. Do you have any recommendations? Thanks.

[@CodingIsFun]

Thanks for watching the video. It sounds to me that you might have trouble with xlwings. For the sake of troubleshooting, could you kindly check out the following tutorial: kzbin.info/www/bejne/n3qkhX2qp9qNeKc In the video, I am going into more depth on how to set up/use xlwings. Once xlwings is running, you should also be able to automate word, as shown in this video. I hope it helps.

[@arcticwildernesssurvival680]

@@CodingIsFun Thank you. I resolved the issue by installing the xlwings add-in. Thanks again for your help!

[@arcticwildernesssurvival680]

@@CodingIsFun Hi, another quick question: is it possible to pull data from multiple excel sheets (one spreadsheet, multiple tabs) at once? Eg. if I have context on two excel sheets that I want render in the same word document. I tried: sht_panel = wb.sheets["PANEL"] sht_other_data = wb.sheets["OTHER_DATA"] context = sht_panel.range('A2').options(dict, expand='table', numbers=int).value context2 = sht_other_data('A2').options(dict, expand='table', numbers=int).value and then doc.render(context) doc.render(context2) doc.save(output_name) BUT it will only render one of those, not both. So I assume I need to define the multiple sheets in just one context variable, but what would this look like? Thanks for your help!

[@CodingIsFun]

@@arcticwildernesssurvival680 I assume there might be a typo: context2 = sht_other_data('A2').options(dict, expand='table', numbers=int).value The 'range' is missing. If that does not resolve it, you could try to merge the two dicts into one and then render the context: final_context = {**context, **context2}

[@arcticwildernesssurvival680]

@@CodingIsFun I actually had the 'range' but dropped it from the youtube comment for some reason.. merging the dictionaries worked great. Thank you for the help! Liked and subscribed!

[@walterruelas6064]

Excellent video, please how can I change the decimal separator from points to commas, I need to work with one decimal value separated the decimal part with a comma. Thanks so much.

[@CodingIsFun]

Thanks for watching. What have you tried so far?

[@walterruelas6064]

@@CodingIsFun I tried to put instead of int str, but doesn't work.

[@walterruelas6064]

The solution I found, eventhough I think it is not optimal is to apply functions in excel to round and convert to text the numbers according to my desired format.

[@CodingIsFun]

@@walterruelas6064 xlwngs will just ensure to read in the datatype correctly (int or float) docs.xlwings.org/en/stable/converters.html. To format your numbers, have a look at the following blog post: pythonguides.com/python-format-number-with-commas/#:~:text=In%20Python%2C%20to%20format%20a,thousand%20places%20starting%20from%20left.&text=After%20writing%20the%20above%20code,appear%20as%20a%20%E2%80%9C%205%2C000%2C000%E2%80%9D. I hope it helps! Happy Coding!

[@anishatg2886]

Hy when I click the update document button, I get a error message saying python was not found. Can you help me how to solve it please

[@CodingIsFun]

Did you install Python?

[@senahugtfl7789]

hi ı have a issue when ı was writing my file path .According to the internet i ve written correct but for ATOM accepted if I only write full absolute path starting ffrom "C:".And it is so unfit could you hepl me ?

[@CodingIsFun]

Thanks for watching. Unfortunately, with that bit of information, I cannot help you. You might want to take some time to write down the exact error message. It would also be great to let me know if you have made any modifications to the initial code I have shared on GitHub. Thanks!

[@senahugtfl7789]

@@CodingIsFun when ı write lie this: with open(".\Input\Names ame.txt") as file: It gives me the errror like this: No such file or directory: '.\\Input\\Names\ ame.txt' the problem is i check the folder and files.They are in there.But my laptop cant find until i havent written the long version like this: C:\***\***\***\***\***\Input\Names ame.txt ı do not know how can ı fix this problem because that one is so long and unfit .

[@CodingIsFun]

@@senahugtfl7789 I suggest using Pathlib when dealing with file paths. Here is a quick start guide: kzbin.info/www/bejne/n6K9Y4luprmMp5o

[@elbadrey]

good tut, try to tell us. How did we find and replace text?

[@CodingIsFun]

Thanks for watching. Here you are: kzbin.info/www/bejne/mYa4m557nNN2oNU

[@sayo6305]

I am getting 'ModuleNotFoundError: No module named 'docxcompose'. I have installed it using pip but still the error persists

[@CodingIsFun]

Thanks for watching. Have you tried to run "pip install docxcompose"? Cheers, Sven ✌️

[@israrhussainrao8022]

how can we add border to the paragraph?

[@CodingIsFun]

Thanks for watching the video. The idea of this project is to do all the styling of your Word template beforehand, like adding borders, position elements, etc. With Python, I am 'just' injecting the values from Excel into the Word document (rather than formatting the Word document using Python).

[@viniciusoliveirablackman578]

Hello, I install the libary but i get the erro "TypeError: 'module' object is not callable

[@CodingIsFun]

Please clone the repor and try again. Thanks!

[@lionelnkaya2359]

Thank you so much for this awesome content. The first part works for me, I am able to render the file based on the template. But when I try to do it using the button on Excel I get this error --------------------------- Package not found at 'MainTemplate.docx' I really do not understand as anyone ran into a similar issue? Thank you for the tutorial!

[@lionelnkaya2359]

It actually works! but because my script is stored on Microsoft OneDrive, for changing the path to current directory I had to use a variable path = r 'pathOnMyComputer' instead of os.chdir(sys.path[0]). Thank you so much @Coding Is Fun for making writing useful Python so pleasant! You have won a new subscriber :)

[@benarnold5738]

I have had the same issue, have you found a fix?

[@CodingIsFun]

I have updated the code to fix this: github.com/Sven-Bo/python-word-automation/commit/39856047afee726ce34dae521f8ad173774eaba9 Please clone the repo and give it another try: github.com/Sven-Bo/python-word-automation

[@Jett-Molly]

Great video, just what I was looking for. I have hit a problem though line 19 & 20. when I type in context it comes up as an error. As the video is 2 years old, has this been updated?

[@CodingIsFun]

Thanks for watching. The error message would be helpful. You can find the latest code in the GitHub repo (see description)

[@Jett-Molly]

@@CodingIsFun thanks for your reply. there is no error code as such, it underlines the word 'content' like it doesn't recognise it and has a 1 next to the file name at the top left of the file. I have only just started learning Python but being able to use it to create reports in word/PDF like you have from Excel data is what I have been looking for and would be really helpful. I will try and find the code in your links

[@Jett-Molly]

@@CodingIsFun I pasted the latest code in and it still doesn't like the word content in the section where you are creating a new file name. it is saying it is an error. I can not attach a screenshot here is there an email I can send it to.?

[@GustavoRios-kl2um]

Could anyone help me with this error? It happens on excel when I try to click the button to Update the Word Document --------------------------- Error --------------------------- Traceback (most recent call last): File "", line 1, in File "c:\users\optimale\desktop\automation\Automation.py", line 10, in os.chdir(sys.path[0]) OSError: [WinError 123] A sintaxe do nome do arquivo, do nome do diretório ou do rótulo do volume está incorreta: '' Press Ctrl+C to copy this message to the clipboard.

[@CodingIsFun]

Thanks for watching. Please use the updated version from GitHub: github.com/Sven-Bo/python-word-automation

[@firstlady9627]

The text file doesnt change to python format. What went wrong on my side?

[@CodingIsFun]

Thanks for watching. Hard to tell from a distance

[@AnqiCheng]

I had error when trying to install python-docx: note: This error originates from a subprocess, and is likely not a problem with pip. ERROR: Failed building wheel for lxml Failed to build lxml ERROR: Could not build wheels for lxml, which is required to install pyproject.toml-based projects

[@CodingIsFun]

You could try: pip install lxml

[@alexandregoncalves5478]

This is amazing!!! Can you provide a example template tags {{ }} only using excel?

[@CodingIsFun]

Thank you for watching the video. Do you mean converting an Excel Workbook to Word? Like, writing the text in an Excel cell and by clicking a button, it should create a Word Document?

[@py_tok5589]

@@CodingIsFun yes please

[@CodingIsFun]

@@py_tok5589 One easy way would be the use of VBA. I found a great blog article about this: www.exceltip.com/applications-word-outlook-in-vba/copy-worksheet-information-to-word-using-vba-in-microsoft-excel.html I went ahead and tested the solution - it works like a charm. In the blog article, you will also find a download link to the example workbook. Hope this solution is working for you.

[@albertovielledent1053]

I'm getting this error whenever I try to use the button in excel: Traceback (most recent call last): File "", line 1, in ModuleNotFoundError: No module named 'word_automation' Anyone with the same issue that might have a solution?

[@CodingIsFun]

Thank you for watching! Please clone the Github repo and try again.

[@ananguyen4509]

@@CodingIsFun : Hi, I face the same problem. Could you please explain more. I try to clone the Github repo and try again but it doesn't work. Thank you.

[@jsrevathy]

I am not able to locate the samplecall macro in my excel. How to add it?

[@CodingIsFun]

Thanks for watching. Have you followed the steps as explained at 1:56 min?

[@jsrevathy]

@@CodingIsFun I am using PyCharm. I installed xlwings package in my project. But it didn't reflect in my Excel. Should I install xlwings some where else? I tried installing it in cmd prompt too.

[@CodingIsFun]

As shown in the video, please use 'xlwings quickstart projectname --standalone'

[@tim942926019]

Hello Sven! I thank you for all your doing for us. I'd like to know how to use a word97-2003(*.doc) file in python

[@CodingIsFun]

Thank you for watching the video and for your question. Unfortunately, I do not know how to implement that right off the bat. I would also need to search the internet for a solution. Sorry that I cannot help!

[@tim942926019]

@@CodingIsFun 🙏

[@elsabiosapo4835]

Amigo no hay tradición al español. Necesito de ley usar esta herramienta. Y no hay subtítulos en español....

[@CodingIsFun]

Hey, sorry about the absence of Spanish subtitles.

[@manipalreddy1458]

--------------------------- Error --------------------------- Traceback (most recent call last): File "", line 1, in File "C:\Users\chitt\OneDrive\desktop\word_automation\word_automation.py", line 10, in os.chdir(sys.path[0]) OSError: [WinError 123] The filename, directory name, or volume label syntax is incorrect: '' Press Ctrl+C to copy this message to the clipboard. --------------------------- OK --------------------------- please help me with this while im pressing the update word document button it is showing like this

[@CodingIsFun]

Thanks for watching. I have made the pathsettings more robust ( github.com/Sven-Bo/python-word-automation/commit/39856047afee726ce34dae521f8ad173774eaba9 ) Please use the latest version: github.com/Sven-Bo/python-word-automation/commits/master Happy Coding!

[@cameronf406]

@@CodingIsFun I think this comment should be stickied at the top. It can save people a LOT of time troubleshooting :)

[@upandabout3132]

Could not import InLineImage...any help

[@CodingIsFun]

Thanks for watching the video. What does the error message say?

[@upandabout3132]

importError: cannot import name ‘InLineImage’ from ‘docxtpl’

[@masalex6764]

06:00

[@CodingIsFun]

?

[@divz2646]

Can you upload and suggests such vidoes for a researcher?

[@CodingIsFun]

Thanks for watching. What exactly do you mean? Please provide some additional information

[@divz2646]

@@CodingIsFun like as a PhD scholar we have to manage data..make pie charts, barcharts,digrams, perform statistical tests...can you suggest some help in this scientific field of ours

[@divz2646]

Also can you guide how to use bioinformatics tools using coding

[@elsabiosapo4835]

graciss brother ya esta en el español. yo deseo automatizar mi trabajo. debo digitar datos que van a una tabla excel todos los dias. y eso me quita tiempo.. y deseo pasarlo del archivo pdf mediante algun codigo que maneje el ocr que detecte las palabras que van a mi tabla excel de forma automatica... y eso me facilitaria enormemente el trabajo.... me daria tiempo para mas cuestiones operativas de las cuales soy responsable... agradezco tu atencion....

[@CodingIsFun]

Thanks so much for watching the video and leaving a comment! Your request is definitely noted. However, I get a ton of requests for custom solutions and, as much as I'd love to help everyone out, I just don't have the time in my schedule to develop and test all of them. I hope you can understand. Happy Coding!

[@gamingkulanthai9046]

xlwings quickstart projectname not working

[@CodingIsFun]

Thanks for watching. Nope, the xlwings quickstart command is still working 😅

[@gamingkulanthai9046]

@@CodingIsFun not working for me it not creating new folder with python file and Excel file

[@CodingIsFun]

@@gamingkulanthai9046 That might be. But with that bit of information, I really cannot help you 😅

[@gamingkulanthai9046]

@@CodingIsFun Is there any other way without using xlwings quickstart projectname command ? . I manually created project folder and created necessary python file and Excel file. I can able to fetch data from Excel sheet and update in word document. I just want to run python file with the help of button from Excel sheet. Can you please help me on this.?

[@valarmorghulis9244]

How to protect a Word File in python?

[@CodingIsFun]

Thanks so much for watching the video and leaving a comment! Your request is definitely noted. However, I get a ton of requests for custom solutions and, as much as I'd love to help everyone out, I just don't have the time in my schedule to develop and test all of them. I hope you can understand. Happy Coding!

[@yossialmogmaman4121]

--------------------------- Error --------------------------- Traceback (most recent call last): File "", line 1, in File "C:\Users\XXXXXXXXXXX\desktop\projects\exceltoword\word_automation\word_automation.py", line 7, in os.chdir(sys.path[0]) OSError: [WinError 123] The filename, directory name, or volume label syntax is incorrect: '' Press Ctrl+C to copy this message to the clipboard. What should I do now? Thanks in advance!

[@navinpandey1534]

Same error

[@zarinadavletova1178]

same error

[@CodingIsFun]

Sorry for the late reply. I have adjusted the path settings to make the code more robust. Check out the changes here: github.com/Sven-Bo/python-word-automation/commit/39856047afee726ce34dae521f8ad173774eaba9 I suggest to clone the latest version here and give it another try: github.com/Sven-Bo/python-word-automation

[@forbidenfox3453]

How to make bulk doc file using this method? Pls answer 🙏

[@CodingIsFun]

Thanks for watching the video. That is also possible. I am not entirely sure how your final desired output should look like. Hence, it is tough for me to provide you with any code snippet. Yet, you might just want to implement a for loop to create several Word Documents. Cheers, Sven

[@forbidenfox3453]

Thank you I've found it, your video is amazing, I'm just a little confused just modifying the code a little to suit my needs

[@forbidenfox3453]

Translated using google translate, because I'm Asian

[@kapibara2440]

9

[@CodingIsFun]

❓

[@FelipeCosta-uc1tc]

Thanks a lot for this video. at fisrt, mine worked just fine. Then I implemented more placeholders and it doesnot work anymore. Tried again from the begining and it keeps giving me a the same error: " doc.render(context)" "jinja2.exceptions.TemplateSyntaxError: Invalid character in identifier"

[@FelipeCosta-uc1tc]

Found it. The problem was my template with special characters, even if I was not going to use them, it seems the cod run all of them.

[@CodingIsFun]

Happy to hear that you figured it out!

[@isaiahbaker1334]

--------------------------- Error --------------------------- Traceback (most recent call last): File "", line 1, in File "c:\users\consultoria3\desktop\word_automation\word_automation.py", line 5, in import matplotlib.pyplot as plt # pip install matplotlib ModuleNotFoundError: No module named 'matplotlib' Press Ctrl+C to copy this message to the clipboard. --------------------------- "I need somebody Help. Not just anybody..."

[@isaiahbaker1334]

--------------------------- Error --------------------------- Traceback (most recent call last): File "", line 1, in File "c:\users\consultoria3\desktop\word_automation\word_automation.py", line 10, in os.chdir(sys.path[0]) FileNotFoundError: [WinError 2] The system cannot find the file specified: 'c:\\users\\consultoria3\\desktop\\word_automation\\word_automation.zip' Press Ctrl+C to copy this message to the clipboard. --------------------------- OK ---------------------------

[@CodingIsFun]

Thanks for watching. Use the updated code from GitHub and ensure to install the requirements (requirements.txt): github.com/Sven-Bo/python-word-automation

[@isaiahbaker1334]

@@CodingIsFun Thankyou so much. If I debug the code it works, but I keep getting this message everytime i hit the button. --------------------------- Error --------------------------- Traceback (most recent call last): File "", line 1, in ModuleNotFoundError: No module named 'word_automation' Press Ctrl+C to copy this message to the clipboard. --------------------------- OK ---------------------------