Shulou(Shulou.com)06/02 Report--

This article will explain in detail how Python generates word documents with specified data in batches. The editor thinks it is very practical, so I share it with you as a reference. I hope you can get something after reading this article.

I. description of requirements

In daily work, often need to deal with files, especially Word, when dealing with Word will encounter a more common scenario: most of the text in the document is fixed, a small part of the content needs to be modified.

At this time, we will mechanically repeat a series of operations such as opening, modifying and saving documents, and the content can be accepted reluctantly. Once there is more content, it is inevitable that we will be impetuous.

Today I'm going to introduce you to a secret weapon-the docxtpl development kit. With this, you just need to write a template and leave the rest to the computer itself.

First of all, you need to install the Python environment and Python development tools on your computer.

If you haven't installed it yet, you can refer to the following article:

If only Python is used to deal with data, crawlers, data analysis or automated scripts, machine learning, etc., it is recommended to use Python basic environment + jupyter, installation using reference Windows/Mac installation, using Python environment + jupyter notebook

If you want to use Python for web project development, etc., it is recommended to use Python basic environment + Pycharm, installation use reference: install under Windows, use Pycharm tutorials, so all and Mac play to Python- installation & use Python/PyCharm.

Introduction of secret weapons

Docxtpl: a powerful package that can be modified primarily by loading the docx document template.

Pandas: provides high-performance, easy-to-use data types and analysis tools

Install related third-party libraries

Press and hold Win+R under Windows to open the running window, enter cmd to enter the command prompt window (Mac opens the terminal), and enter the following command to install the relevant package:

Pip install docxtpl

Pip install pandas

Use case

Generate a collection of enrollment notices for freshmen from the School of computer and Information Engineering in a school. The contents of the word template and form are as follows (the part to be completed in double brackets):

The effect is as follows

Second, start to use your head.

Step 1: import related modules:

From docxtpl import DocxTemplateimport pandas as pdimport os

Step 2: create a new folder with Python to store the admission notice. If the folder already exists, the code will skip this step:

Zpath = os.getcwd () +'\\'# get the current path zpath = ringing E:\ python\ tj' +'\ 'file_path = zpath + r'\ Notification Collection 'try: os.mkdir (file_path) # create a first-level directory except: pass

Step 3: read the data in the csv file:

By assigning each column of data in the table to a variable of type series, you can think of series as an array.

Data = pd.read_csv (zpath+'AdmissionList.csv', encoding='gbk') # read the target data in csv name = data ["name"]. Str.rstrip () # str.rstrip () is used to remove blank academy = data ["academy"]. Str.rstrip () major = data ["professional"]. Str.rstrip () begin_date = data ["start time"]. Str.rstrip () end_date = data ["end time"]. Str.rstrip ()

Step 4: write the data to the template:

Iterate through each row of the table and store the data in the dictionary list

Num = data.shape [0] # get the number of rows for i in range (num): context = {"name": name [I], "College": academy [I], "Professional": major [I], "start time": begin_date [I], "end time": end_ date [I]}

Selected template

Tpl = DocxTemplate (zpath+' admission notice .docx')

Render replacement to write the contents of context into the word template

Tpl.render (context) # render replacement

Keep an admission notice with the name of * *.

Tpl.save (admission letter of file_path+r "\ {} .docx" .format (name [I]))

Repeat the above num (that is, the number of rows of data in the table) several times, and after writing these, you can find the generated file in file_path.

Possible errors:

File name garbled: you can try to change the decoding method to gbk

Permission problem: the data file that needs to be read may be in use. Just close it.

The generated word file has a messy number of lines: you can write str.rstrip () as str.rstrip ('\ n')

You can only generate the same word document: each time you render, the template is re-selected.

This is the end of this article on "how Python batch generates word documents with specified data". I hope the above content can be helpful to you, so that you can learn more knowledge. if you think the article is good, please share it out for more people to see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.