1.批量获取文件名
import os
path="C:/Users/32891/Desktop/one(完成)"
path_list=os.listdir(path)
path_list.sort()
data=[]
for filename in path_list:
data.append(filename)
print(data)
2.将数据写入Excel
方法一
import pandas as pd
import xlsxwriter as xw
def xw_toExcel(data, fileName):
workbook = xw.Workbook(fileName)
worksheet1 = workbook.add_worksheet("sheet1")
worksheet1.activate()
title = ['文件名']
worksheet1.write_row('A1', title)
i = 2
for j in range(len(data)):
insertData = [data[j]]
row = 'A' + str(i)
worksheet1.write_row(row, insertData)
i += 1
workbook.close()
fileName = '测试.xlsx'
Data=data
xw_toExcel(Data, fileName)
方法二
import pandas as pd
dataframe = pd.DataFrame(data)
dataframe.to_excel("D:实验数据.xls" , sheet_name="data", na_rep="na_test",header=0)