Python把TXT写入Excel

import xlwt

def txt2xls(filename):
    # 创建一个workbook 设置编码
    workbook = xlwt.Workbook(encoding='utf-8')
    # 创建一个worksheet
    worksheet = workbook.add_sheet('My Worksheet')
    with open(filename, 'r') as f1:
        i = 0
        while i < 55:
            data = f1.readline()
            data = data.replace('n', '')
            if data:
                i += 1
                # 写入excel
                # 参数对应 行, 列, 值
                worksheet.write(i, 0, label=data)
            else:
                continue
    # 保存
    workbook.save('Excel_test.xls')

if __name__ == '__main__':
    txt2xls(filename='or.txt')