import os import openpyxl def create_excel_from_folder_structure(folder_path): # 创建一个新的工作簿并选择活动工作表 wb = openpyxl.Workbook() ws = wb.active # 在Excel中开始的行和列 row = 1 # 处理每个文件夹的函数 def process_folder(path, level): nonlocal row # 列出当前目录中的所有文件和文件夹 for entry in sorted(os.listdir(path)): full_path = os.path.join(path, entry) # 检查是否为目录 if os.path.isdir(full_path): # 写入文件夹名称 ws.cell(row=row, column=level + 1, value=entry) row += 1 # 递归处理子文件夹 process_folder(full_path, level + 1) # 处理提供的文件夹路径 process_folder(folder_path, 0) # 保存工作簿到指定的父目录下 parent_directory = os.path.dirname(folder_path) excel_file = os.path.join(parent_directory, "Folder_Structure.xlsx") wb.save(excel_file) # 打印文件的完整路径 print(f"Excel文件已保存在: {excel_file}") return excel_file # 请求输入文件夹路径 folder_path = input("请输入文件夹的路径: ") create_excel_from_folder_structure(folder_path)