python
import os
import xlwt
def filelist(path):
filelist = []
n = 0
for root,folder,files in os.walk(path):
for file in files:
n += 1
filelist.append(os.path.splitext(file)[0])
return filelist
path1 = r'C:\Users\zhaohui\Desktop\1'
path2 = r'C:\Users\zhaohui\Desktop\2' #缺失
diff = set(filelist(path1)).difference(set(filelist(path2)))
for name in diff:
print('no file:',name)
#将缺失文件名字写入EXCEL表格
workbook = xlwt.Workbook()
worksheet = workbook.add_sheet('lost files')
n = 0
for name in diff:
worksheet.write(n,0,name)
n += 1
workbook.save(r'C:\Users\zhaohui\Desktop\lost_files.xls')