json文件转xls文件

#写成json的文本文件内容，转换为xls文件
import xlwt
import os
import json
def get_(path):
    with open(path,'r',encoding='utf-8') as f:
        content=f.read()
    return content
def json_(str):
    d=json.loads(str)
    d=sorted(d.items(),key=lambda item:item[0],reverse=False)
    return d
def json_16(str):
    d=json.loads(str)
    return d
def save_(d,path):
    workbook=xlwt.Workbook(encoding='utf-8')
    sheet1=workbook.add_sheet('sheet1')
    r=0
    c=1
    for key,value in d:
        sheet1.write(r,0,key)
        for i in value:
            sheet1.write(r,c,i)
            c+=1
        r+=1
        c=1
    workbook.save(path)
def save_16(d,path):
    workbook=xlwt.Workbook(encoding='utf-8')
    sheet1=workbook.add_sheet('sheet1')
    for a,b in enumerate(d):
        for c,v in enumerate(b):
            sheet1.write(a,c,v)
    workbook.save(path)
if __name__ == "__main__":
    p1=r'E:\vscode\code\testwork\txtfile\5.txt'
    p2=r'E:\vscode\code\testwork\txtfile\5.xls'
    save_16(json_16(get_(p1)),p2)
    print('END')