2021-08-11

python 读取excel 对应生成word文档

读取的excel格式如下：

需求：根据不同的校区生成不同路径的word文档，文档名字为学生的名字

import pandas as pd
from pandas import DataFrame
import docx 
df = pd.read_excel('WMR统计名单2021.xls')
height,width = df.shape

#print(height,width,type(df))
#print(df.loc[0]['学员姓名'])

path = "C:\\Users\\KUGE\\Desktop\\test1\\"
count = 0
for i in range(height):
    path1 = path +df.loc[i]['所属校区']+"\\"
    str1 =  df.loc[i]['学员姓名']+".docx"
    doc = docx.Document()
    doc.save(path1+str1)
    count += 1
    print(count)