python實作子檔案夾中檔案數目批量識別并匯出條件子檔案夾名單為Excel
講解
略
代碼
import os
import xlwt
# 將資料寫入新檔案 file_path為目標Excel（不存在時會自動創建）
def data_write(file_path, datas):
f = xlwt.Workbook()
sheet1 = f.add_sheet(u'sheet1', cell_overwrite_ok=True)
j = -1
sheet1.write(0,0,'序號')
sheet1.write(0,1,'檔案名')
for data in datas:
for x in range(len(datas)):
sheet1.write(x+1, 1, datas[x])
sheet1.write(x+1, 0, j)
j += 1
f.save(file_path)
path = r"C:\Users\Lenovo\Desktop\新建檔案夾"#檔案夾絕對路徑
out_floder = os.listdir(path)
error_floders = []
error_num = 0
for folders in out_floder:
folder = os.path.join(path, folders)
# print(folders)
in_folder = os.listdir(folder)
# print(in_folder)
filenum = 0
for lists in os.listdir(folder):
sub_path = os.path.join(folder, lists)
# print(sub_path)
if os.path.isfile(sub_path):
filenum = filenum + 1
num = filenum
if num < 3:
error_floders.append(folders)
error_num += 1
print('姓名: ', folders)
print('檔案數量: ', num)
print("共有{0}個檔案格式錯誤，其中包括{1}".format(error_num,error_floders))
data_write(r"C:\Users\Lenovo\Desktop\test.xls", error_floders)
運行前
運行程序列印
運行結果另存為Excel
轉載請註明出處，本文鏈接：https://www.uj5u.com/houduan/291866.html
標籤：python
上一篇：python資料結構之演算法分析