#!/usr/bin/env python # -*- coding: utf-8 -*- # @Author : xxxx # @Time : 2020/12/21 21:17 #a.txt内容是 1234 # 5557 # import xlrd import xlwt path="a.txt" def get_list(path): file = open(path, "r", encoding='utf-8') lines = file.readlines() a = [] for line in lines: line=line.strip("\n")#去掉换行符,输出 # print(line) list=line.split(',')#以,切割 a.append(list)#将list插入空列表 # print(a) #输出如a=[[1,2,3,4],[5,5,5,7]] return a
def write_xls(list): xls = xlwt.Workbook() #获取实例 sheet=xls.add_sheet("Sheet1")#添加一个sheet for i in range(len(list)):#行循环 for j in range(len(list[0])):#列循环 sheet.write(i,j,list[i][j])#向sheet中写入数据.如第一行第一列就是a[1][1]=1 xls.save("result1.xls")#写入后保存 return "保存成功" data=get_list(path) # print(data) print(data[0]) print(data[1]) print(write_xls(get_list(path))) #