|

楼主 |
发表于 2021-12-5 10:49:31
|
显示全部楼层
import os
import pandas as pd
def get_file_path(root_path,file_list,dir_list):
dir_or_files = os.listdir(root_path)
for dir_file in dir_or_files:
dir_file_path = os.path.join(root_path,dir_file)
if os.path.isdir(dir_file_path):
dir_list.append(dir_file_path)
get_file_path(dir_file_path,file_list,dir_list)
else:
file_list.append(dir_file_path)
file_list = []
dir_list = []
root_path = os.getcwd()
get_file_path(os.getcwd(),file_list,dir_list)
s = pd.Series(file_list)
writer = pd.ExcelWriter("文件路径.xlsx")
s.to_excel(writer)
writer.save() |
|