# coding=utf-8import jsonimport xlwt"""把student.txt文件中的内容 ，写入student.xls中{        "1":["张三",150,120,100],        "2":["李四",90,99,95],        "3":["王五",60,66,68]    }"""def load_json_file(filename):    """    加载json文件    :param filename: 文件名称    :return:    """    f = file(filename)  # 创建一个file文件    json_data = json.load(f)    return json_datadef save_data_to_excel(data):    save_file = xlwt.Workbook()    # 新建一个Excel 文件    data_table = save_file.add_sheet("sheet0")  # 添加一个sheet    row = 0    for k, v in data.items():        data_table.write(row, 0, k)        data_table.write(row, 1, v[0])        data_table.write(row, 2, v[1])        data_table.write(row, 3, v[2])        data_table.write(row, 4, v[3])        row = row+1        save_file.save("student1.xls")if __name__ == "__main__":    save_data_to_excel(load_json_file("student.txt")) 运行结果：