#!/usr/bin/env python
#coding=utf-8

import xlsxwriter,json

def json2xls():
    wb=xlsxwriter.Workbook('student.xls')
    ws=wb.add_worksheet("student")

    with open('./student') as f:
        data=json.load(f)
        for i in range(len(data)):
            ws.write(i,0,i+1)
            json_data=data[str(i+1)]
            for j in range(len(json_data)):
                ws.write(i,j+1,json_data[j])
    wb.close()

if __name__=='__main__':
    json2xls()



50acbd6027c494e3676f66c081b9de9b4b2ea2bf
<mask token>

<mask token>


def json2xls():
    wb = xlsxwriter.Workbook('student.xls')
    ws = wb.add_worksheet('student')
    with open('./student') as f:
        data = json.load(f)
        for i in range(len(data)):
            ws.write(i, 0, i + 1)
            json_data = data[str(i + 1)]
            for j in range(len(json_data)):
                ws.write(i, j + 1, json_data[j])
    wb.close()


<mask token>

<mask token>


def json2xls():
    wb = xlsxwriter.Workbook('student.xls')
    ws = wb.add_worksheet('student')
    with open('./student') as f:
        data = json.load(f)
        for i in range(len(data)):
            ws.write(i, 0, i + 1)
            json_data = data[str(i + 1)]
            for j in range(len(json_data)):
                ws.write(i, j + 1, json_data[j])
    wb.close()


if __name__ == '__main__':
    json2xls()

import xlsxwriter, json


def json2xls():
    wb = xlsxwriter.Workbook('student.xls')
    ws = wb.add_worksheet('student')
    with open('./student') as f:
        data = json.load(f)
        for i in range(len(data)):
            ws.write(i, 0, i + 1)
            json_data = data[str(i + 1)]
            for j in range(len(json_data)):
                ws.write(i, j + 1, json_data[j])
    wb.close()


if __name__ == '__main__':
    json2xls()

#!/usr/bin/env python
#coding=utf-8

import xlsxwriter,json

def json2xls():
    wb=xlsxwriter.Workbook('student.xls')
    ws=wb.add_worksheet("student")

    with open('./student') as f:
        data=json.load(f)
        for i in range(len(data)):
            ws.write(i,0,i+1)
            json_data=data[str(i+1)]
            for j in range(len(json_data)):
                ws.write(i,j+1,json_data[j])
    wb.close()

if __name__=='__main__':
    json2xls()


