python文件目录

"""
用python批量获取某路径文件夹及子文件夹下的指定类型文件excel，并按指定路径进行存储
"""

import os
import shutil

file_excel = []

path = os.getcwd()
path_listdir = os.listdir(path)

for s in path_listdir:
    path_excel = os.path.join(path, s)  # 将文件名加入到当前文件路径后面
    if os.path.isfile(path_excel):  # 如果是文件
     #   print(os.path.splitext(newdir)[0])
      #  print(os.path.splitext(newdir)[1])

        if os.path.splitext(path_excel)[1] == ".xlsx":  # 如果文件是".pdb"后缀的
            file_excel.append(path_excel)
         #   print(soundfile)
    elif os.path.isdir(path_excel):  # 如果是路径
        continue

#for i in range(len(soundfile)):
   # print(soundfile[i])
#print(len(soundfile))

#print(soundfile)


for i in range(len(file_excel)):

    path_dir = os.path.split(file_excel[i])[0]
    print(path_dir)
    path_file = os.path.split(file_excel[i])[1]
    print(path_file)
  #  print(path_1)
    filename = path_dir + '/' + path_file
    filename_bak = path + '/bak/' + path_file
    shutil.copyfile(filename, filename_bak)
  #  print(str(i) + '/' + str(len(soundfile)))