python读取文件名写入到excel表

import os
import sys
import xlwings as xw

department = "test"
face_path = "C:/Users/Administrator/Desktop/face/"
pathDir = os.listdir(face_path)
app = xw.App(visible = True,add_book = False)  ##启动excel程序窗口

##打开桌面FaceInfo.xlsx工作簿(工作簿必须存在，并且不能处于已打开的状态)
workbook = app.books.open(r"C:/Users/Administrator/Desktop/FaceInfo.xlsx")

worksheet = workbook.sheets["group"]    ##选中工作表“group”
worksheet.range('A2').value = department

worksheet = workbook.sheets["Sheet1"]   
worksheet.range('J2').options(transpose=True).value = pathDir
j = 2
for i in pathDir:
    worksheet.range('A'+str(j)).options(transpose=True).value = i.split('.')[0]
    worksheet.range('K'+str(j)).options(transpose=True).value = department
    j+=1

workbook.save(r"C:/Users/Administrator/Desktop/FaceInfo.xlsx")
workbook.close()
app.quit()

打包exe程序带UI界面源码

import os
import sys
import easygui
import xlwings as xw

msg = "请输入相关路径"
title = "图片名批量写入excel表"
fieldNames = ["部门名称：","图片路径：","excel路径："]
fieldValues = []


fieldValues = easygui.multenterbox(msg,title,fieldNames)

a = fieldValues[0]
b = fieldValues[1]
c = fieldValues[2] + os.sep + "FaceInfo.xlsx"

department = a
face_path = b
pathDir = os.listdir(face_path)
app = xw.App(visible = True,add_book = False)  ##启动excel程序窗口

workbook = app.books.open(c)

worksheet = workbook.sheets["group"]    ##选中工作表“group”
worksheet.range('A2').value = department

worksheet = workbook.sheets["Sheet1"]   
worksheet.range('J2').options(transpose=True).value = pathDir
j = 2
for i in pathDir:
    worksheet.range('A'+str(j)).options(transpose=True).value = i.split('.')[0]
    worksheet.range('K'+str(j)).options(transpose=True).value = department
    j+=1

workbook.save(c)
workbook.close()
app.quit()