#coding:utf-8nimport xlwtnn#读取目标文本文件ndef get_str(path):n f = open(path, encoding="utf-8")n data = f.read()n f.close()n return datannndef save_excel(save_path,sheetname,column_name_list,read_list):n workbook = xlwt.Workbook()nn sheet1 = workbook.add_sheet(sheetname=sheetname)nn for i in range(0,len(column_name_list)):n sheet1.write(0,i,column_name_list[i])n i = 1n for v in read_list:n kval = v.split('
:')n for j in range(0, len(kval)):n sheet1.write(i + 1, j, kval[j])n print(kval[j])n i = i + 1n#保存为Excel文件ndef save_excel(save_path,sheetname,column_name_list,read_list):n workbook = xlwt.Workbook()n sheet1 = workbook.add_sheet(sheetname=sheetname)n for i in range(0,len(column_name_list)):n sheet1.write(0,i,column_name_list[i])n i=1n for v in read_list:n kval=v.split('
:')n for j in range(0,len(kval)):n sheet1.write(i+1,j,kval[j])n i=i+1n workbook.save(save_path)n print('信息保存 OK
,记录条数共计:'+str(len(read_list)))nnif __name__ == '__main__':n path = input("请输入文件路径:")n save_path = input("请输入文件保存路径
:")n sheet_name = input("请输入sheetname:")n column_name = input("请输入列名,并且使用英文逗号隔开:")n column_name_list = column_name.split(',')nn read_str = get_str(path)n read_list = read_str.split('n')n save_excel(save_path, sheet_name, column_name_list, read_list)