按照excel表格内容实现文件整理归类

import os
import shutil
import xlrd

path = 'F:/task2/'
for i in range(37):
    isExists = os.path.exists(path+str(i))
    if not isExists:
        os.makedirs(path+str(i))
        print("%s 目录创建成功" % i)
    else:
        print("%s 目录已存在" % i)
        continue

os.chdir("F:/task2")
myfiles = []
for myfile in os.listdir():
    if myfile.endswith('xlsx'):
        myfiles.append(myfile.split('.')[0])
for folderName, subfolders, filenames in os.walk("F:/task2"):
    myfolder = folderName.split(os.path.sep)
    if myfolder[len(myfolder)-1] in myfiles:
        shutil.move(myfolder[len(myfolder)-1] + '.xlsx', folderName)

for k in range(1, 37):
    dirpath = r'F:/task2'
    dstpath = r'F:/task2/'
    dstpath = os.path.join(dstpath, str(k))
    datapath = r'C:/calling/'
    datapath = os.path.join(datapath, str(k) + '.xls')
    x1 = xlrd.open_workbook(datapath)
    sheet1 = x1.sheet_by_name("%s" % k)
    idlist = sheet1.col_values(6)
    file_names = os.listdir(dirpath)
    for i in idlist:
        for j in file_names:
            if i == j:
                src = os.path.join(dirpath, '%s' % i)
                print("src=", src)
                dst = os.path.join(dstpath, '%s' % i)
                print("dst=", dst)
                shutil.move(src, dst)