用python读取json格式内容并保存到excel中

python版本 python2.7

所需安装库 xlwt

# -*- coding: utf-8 -*
import json,xlwt,os


def readjson():
    path = 'C:/Users/lenovo/Desktop/xueli'#指定文件夹路径
    files = os.listdir(path)#得到文件夹下的所有文件名称
    s = []
    for file in files:
        if not os.path.isdir(file):#判断是否为文件夹，如果不是则继续
            with open(path+'/'+file,'r') as fr:#用with打开文件
                data = json.load(fr) # 用json中的load方法，将json串转换成字典
                s.append(data)#保存所有字典到列表中
    return s


def writeM():
    datas = readjson()
    title = ["age","birthday","collegeName","degree","gender","graduateTime","graduateYears","idNo","message","name","photo","photoStyle","specialty","startTime","studyResult","studyType"