读txt写入excel简单操作

# -*- coding: utf-8 -*-
import xlwt
def read_text():
    data=[]
    with open ('datas.txt', 'r', encoding='utf-8') as f:
        #逐行读取，并遍历
        for line in f.readlines():
            # 去除末行的空格换行
            line = line.strip('\n')
            #根据数据分割符帅选数据
            x=line.split('#',4)
            #添加到列表
            data.append(x)
        #返回所有数据的列表集合
        return data

def wirte_excel(data,filename):

    # 创建工作簿 设置编码
    file = xlwt.Workbook(encoding='utf-8')

    # 创建一个worksheet
    sheet = file.add_sheet('My sheet')

    # 写入excel
    # 参数对应 行, 列, 值
    for i in range(len(data)):
        row=data[i][0]
        col=data[i][1]
        value=data[i][2]
        sheet.write(row, col, label=value)

    # 保存
    file.save('{}.xls'.format(filename))

def covert(data):
    datas = read_text()
    info = []
    for i in range(len(datas)):
        row = datas[i]
        for j in range(len(row)):
            col = row[j]
            # print(i,j,col)
            info.append([i, j, col])
    return info

if __name__ == '__main__':
    datas=read_text()
    data_write=covert(datas)
    wirte_excel(data_write,'题目')

datas.txt

序号#类型#题目#答案
1#1#选择题1#A
2#1#选择题2#B
3#1#选择题3#C
4#1#选择题4#D
5#2#判断题1#√
6#2#判断题2#√
7#2#判断题3#×
8#2#判断题4#×