import os
import xlwt
#"将一个文件夹下所有的文件夹的名称提取并写入Excel中"
workbook = xlwt.Workbook()
worksheet = workbook.add_sheet('pages')
rootdir = r"C:\Users\86152\Desktop\曲线数据"
i = 0
for dirnames in os.listdir(rootdir):
worksheet.write(i,0,dirnames)
i+=1
workbook.save(r'C:\Users\86152\Desktop\曲线数据\filenames.xls')
print(i)
import os
import xlwt
#"将一个文件夹下所有的文件夹的名称提取并写入Excel中"
folder = input("请输入文件夹名(从根目录开始,例:F:\data):")
workbook = xlwt.Workbook()
worksheet = workbook.add_sheet('pages')
rootdir = folder
i = 0
for dirnames in os.listdir(rootdir):
worksheet.write(i,0,dirnames)
i+=1
filelocation = input("请输入文件保存位置(从根目录开始,以.xls结束,例:F:\data\file.xls):")
workbook.save(filelocation)
print(i)