Python遍历某目录下所有文件夹，并用excel导出路径和文件夹名称

直接上代码：

import os
import openpyxl

def get_directory_structure(path):
    file_data = []
    
    for root, dirs, files in os.walk(path):
        print("目录:", root)
        for dir in dirs:
            print("文件夹:", dir)
            file_data.append((root, dir))
    return file_data
        
def export_to_excel(data, excel_file):
    wb = openpyxl.Workbook()
    ws = wb.active
    ws.append(['Absolute Path', 'Folder Name'])
    for row in data:
        ws.append(row)
    wb.save(excel_file)
    wb.close()

if __name__ == "__main__":
    
    target_directory = "D:/项目/SVN/Project Delivery"
    output_excel_file = "C:/Users/abc/Downloads/ProjectDeliveryStructure.xlsx"
    
    if os.path.exists(target_directory):
        file_data = get_directory_structure(target_directory)
        export_to_excel(file_data, output_excel_file)
        print("Excel export completed.")
    else:
        print("Target directory not found.")

以上~