python读取openapijson文件所有接口信息

import openpyxl
import json

from apistar.schemas import OpenAPI

with open(r"E:\下载\default_OpenAPI.json", "r", encoding="utf-8") as f:
    content = json.load(f)

import jsonpath

#
# paths = jsonpath.jsonpath(content, '$.paths[*].[*].summary')
# print(summary)
paths=jsonpath.jsonpath(content, '$.paths')

c=[]
for path in paths:
    for k,vs in path.items():
        a=[]
        a.append(k)
        for k,v in vs.items():
            b = []
            b.append(v["tags"][0])
            b.append(v["summary"])
            pre=a[0]
            b.append(k)

            b.append(pre)

            c.append(b)
# print(c)

filename = "capmus_api.xlsx"
wb = openpyxl.Workbook()  # 创建工作簿对象
ws = wb['Sheet']  # 创建子表
ws.append(['module','name', 'method','path'])  # 添加表头

for i in range(len(c)):
    d = c[i]
    ws.append(d)

wb.save(filename)