python：获取脚本目录下的文件清单

import os
from openpyxl import Workbook

directory = os.getcwd()
file_names = os.listdir(directory)
wb = Workbook()
ws = wb.active
for i, file_name in enumerate(file_names, start=1):
    ws.cell(row=i, column=1, value=file_name)

excel_file_path = "文件清单.xlsx"
wb.save(excel_file_path)

print(f"文件名已保存到 {excel_file_path}")