python 生成指定路径下所有excel文件的目录,并且可以跳转到指定sheet,
代码如下:
import os
from pathlib import Path
import xlwt
import datetime
import xlrd
def get_path():
while True:
path = input("请输入需要查找的目录:")
if Path(path).exists():
break
return os.listdir(path), path
def add_excel():
wbk = xlwt.Workbook(encoding='utf-8')
sheet = wbk.add_sheet('目录', cell_overwrite_ok=True)
return sheet, wbk
def get_file(path, file_list, data_list):
for item in file_list:
try:
item_path = os.path.join(path, item)
if os.path.isdir(item_path):
get_file(item_path, os.listdir(item_path), data_list)
print(f"{item} 文件检索完成")
data_list.append(dict(name=item, path=item_path, dir_path=path))
except:
print(f"{item} 文件检索失败,跳过检索")
def save_excel(wbk, path):
today &