第 0014 题： 纯文本文件 student.txt为学生信息, 里面的内容（包括花括号）如下所示：

{
	"1":["张三",150,120,100],
	"2":["李四",90,99,95],
	"3":["王五",60,66,68]
}

请将上述内容写到 student.xls 文件中，如下图所示：

第 0015 题： 纯文本文件 city.txt为城市信息, 里面的内容（包括花括号）如下所示：

{
    "1" : "上海",
    "2" : "北京",
    "3" : "成都"
}

请将上述内容写到 city.xls 文件中，如下图所示：

第 0016 题： 纯文本文件 numbers.txt, 里面的内容（包括方括号）如下所示：

[
	[1, 82, 65535], 
	[20, 90, 13],
	[26, 809, 1024]
]

请将上述内容写到 numbers.xls 文件中，如下图所示：

#encoding:utf-8
 
import json
import xlwt
 
# json.loads可转换为dict
def read_content(path):
    with open(path,"r",encoding="utf8") as f:
        content = f.read()
    return json.loads(content)
 
def write_to_excel(filename,sheetname,datas):
    workbook = xlwt.Workbook(encoding="utf8")
    worksheet = workbook.add_sheet(sheetname)
    for i,value in enumerate(datas):
        for j,v in enumerate(value):
            worksheet.write(i,j,v)
    workbook.save(filename)
 
def write_to_excel3(data):
    workbook = xlwt.Workbook(encoding="utf8")
    worksheet = workbook.add_sheet('student')
    i=0
    for k,value in dict(data).items():
        j = 0
        worksheet.write(i,j,k)
        for v in value:
            j += 1
            worksheet.write(i,j,v)
        i += 1
    workbook.save("student.xls")
 
def write_to_excel1(data):
    workbook = xlwt.Workbook(encoding="utf8")
    worksheet = workbook.add_sheet('student')
    i = 0
    for k, value in dict(data).items():
        worksheet.write(i,0,k)
        worksheet.write(i,1,value)
        i += 1
    workbook.save("city.xls")
 
def write_to_excel2(data):
    workbook = xlwt.Workbook(encoding="utf8")
    worksheet = workbook.add_sheet('student')
    i = 0
    for k, value in dict(data).items():
        print(k,value)
        worksheet.write(i,0,k)
        worksheet.write(i,1,value)
        i += 1
    workbook.save("city.xls")
 
if __name__ == '__main__':
    #student.txt
    data = read_content("student.txt")
    datas = []
    for k,v in data.items():
        datas.append([k]+v)
    write_to_excel("student.xls","student",datas)
 
    # city.txt
    data = read_content("city.txt")
    datas = []
    for k,v in data.items():
        datas.append([k,v])
    write_to_excel("city.xls", "city", datas)
 
    # numbers.txt
    data = read_content("numbers.txt")
    write_to_excel("number.xls","numbers",data)