读取文件下的文件名并存储在excel文件中

import os
import numpy as np
import pandas as pd
import shutil
from openpyxl import load_workbook
from openpyxl import workbook
#读取的目标文件夹路径
file_path=('G:\\360MoveData\\Users\\Administrator\\Desktop\\长庆项目整理过的文件\\解剖区测井数据')
file_name_list=os.listdir(file_path)
print(type(file_name_list))
print(file_name_list)

#存储文件名的excel路径
savepath='G:\\360MoveData\\Users\\Administrator\\Desktop\\qw2.xlsx'
wb2 = load_workbook(savepath)  
#print(wb2.sheetnames)
ws2 =  wb2.get_sheet_by_name('Sheet1')
for name in file_name_list :
    m=name.split()
    ws2.append(m)
wb2.save(savepath)