37,720
社区成员
发帖
与我相关
我的任务
分享
import os
import xlrd
def updateData(filename1, filename2):
with xlrd.open_workbook(filename1) as f1:
sn = f1.sheet_by_index(0)
for _ in range(sn.nrows):
row = sn.row_values(_)
print(row)
def getFileNameList(tmpDir):
ff = []
for r, d, f in os.walk(tmpDir):
for _ in f:
a, b = os.path.splitext(_)
tf = (r + '\\', a, b)
ff.append(tf)
return ff
dir1,dir2 = r"c:\file1", r'c:\file2'
f1 = getFileNameList(dir1)
f2 = getFileNameList(dir2)
for ff2 in f2:
for ff1 in f1:
if ff2[1] in ff1[1]:
updateData(''.join(ff1), ''.join(ff2))