读写xlsx和json操作

import openpyxl
import random
import json


def writeExcel():
    # 创建一个xlsx文件
    wb = openpyxl.Workbook()
    # 创建sheet
    wb.create_sheet("20220225")
    wb.create_sheet("20220226")
    sheet_list = wb.sheetnames
    print(sheet_list)
    # 删除sheet
    wb.remove(wb["Sheet"])
    sheet_list = wb.sheetnames
    print(sheet_list)
    # 写入数据
    name_list = ["姓名", "课程", "分数"]
    col = 1
    for i in name_list:
        wb["20220225"].cell(row=1, column=col, value="姓名")
        col += 1
    row = 2
    for j in range(10):
        wb["20220225"].cell(row=row, column=1, value=f"张三{j}")
        wb["20220225"].cell(row=row, column=2, value=f"语文")
        wb["20220225"].cell(row=row, column=3, value=random.randint(77, 100))
        row += 1
    # 保存表格
    wb.save("result.xlsx")


def readEx