problem0014txt存入xls
第 0014 题: 纯文本文件 student.txt为学生信息, 里面的内容(包括花括号)如下所示:
{
"1":["张三",150,120,100],
"2":["李四",90,99,95],
"3":["王五",60,66,68]
}
请将上述内容写到 student.xls 文件中,如下图所示:
- 读取文本,由<‘class str’> 转化为 <‘class dict’>
- 使用xlwt库来生成新的xls文件
demo:
#!/bin/python3
import xlwt
def get_text():
with open('student.txt',encoding='utf-8') as f:
str_temp=f.read()
data = eval(str_temp)
return data
def create_xls(dic):
wb = xlwt.Workbook()
ws = wb.add_sheet('Student')
row = 0
for k,v in dic.items():
ws.write(row,0,k)
col = 1
for items in v:
ws.write(row,col,items)
col += 1
row += 1
wb.save('student.xls')
if __name__ == '__main__':
create_xls(get_text())