python文本导出,Python纯文本导出Excel表格

纯文本文件student.txt写到student.xls文件中。

student.txt结构：

#-*-coding: utf-8-*-

import xlwt

with open('student.txt', 'r', encoding='utf-8') as f:

data = f.read()

_student = eval(data)

student = list()

for i in range(1, 4):

info = _student[str(i)]

student.append(i)

student.extend(info)

row = len(_student)/len(student)

def horz_left(x, y, data):

algnt = xlwt.Alignment()

algnt.horz = xlwt.Alignment.HORZ_LEFT

style = xlwt.XFStyle()

style.alignment = algnt

table.write(x, y, data, style)

file = xlwt.Workbook()

table = file.add_sheet('student')

for i in range(len(student)):

if not i % 5:

horz_left(i//5, i % 5, student[i])

else:

table.write(i//5, i % 5, student[i])

file.save('student.xls')

运行结果student.xls: