通过读取excel文件挑选多个文件夹中的照片并集中

一个小程序，就不用自定义函数了，难看就难看点吧

import os
from win32com.client import Dispatch
from shutil import copyfile

#获取路径
this_path = os.path.abspath('.')
excel_path = this_path + '\上海电信通讯录.xlsx'
pic_path = this_path + '\上海电信员工照片'
lingdao_path = pic_path + '\领导照片'

#读取excel内容
xl = Dispatch("Excel.Application")
xl.Visible = False #True是显示， False是隐藏
xl.DisplayAlerts = 0
xlBook = xl.Workbooks.Open(excel_path,False)
xs = xlBook.Sheets('领导')
max_row = xs.UsedRange.Rows.Count + 1
for i in range(2,max_row):
    Employee_Name = xs.Cells(i,1).Value
    Employee_ID = str(int(xs.Cells(i,3).Value))
    Employee_Partment = xs.Cells(i, 6).Value
    Employee_pic1 = pic_path + '\\' + Employee_Partment + '\\' + Employee_Name + '.jpg'
    Employee_pic2 = pic_path + '\\' + Employee_Partment + '\\' + Employee_Name + '-' + Employee_ID + '.jpg'
    new_pic = lingdao_path + '\\' + Employee_Name + '-' + Employee_ID + '.jpg'
    if os.path.exists(Employee_pic1):
        copyfile(Employee_pic1, new_pic)
    else:
        pass
    if os.path.exists(Employee_pic2):
        copyfile(Employee_pic1, new_pic)
    else:
        pass
xlBook.Close(True)
xl.quit()