import os import openpyxl

打开文件夹

folder_path = r"C:\Users\example_folder" file_names = os.listdir(folder_path)

新建excel表格

wb = openpyxl.Workbook() ws = wb.active

将文件名填入A列位置

for i in range(len(file_names)): ws.cell(row=i+1, column=1).value = file_names[i]

保存excel表格

wb.save('file_names.xlsx')