python将文件夹里所有的txt文件内容写入excel

# coding=utf-8import osimport xlwt# import xlrdfile_path = 'D:\\data\\test.xls'#要写入的文件f = xlwt.Workbook(encoding='utf-8', style_compression=0)sheet = f.add_sheet('sheet1')pathDir = os.listdir("D:\\data\\sub")#txt文件放置在sub文件夹中，用来获取sub文件夹内所有文件目录i = 0for s in pathDir:    newDir = os.path.join("D:\\data\\sub", s)#把获取的文件路径整合    f1 = open(newDir, 'r')    lines = f1.readlines()    for line in lines:        sheet.write(i, 0, line)        i = i+1print(i)f.save(file_path)