import json
import openpyxl
from openpyxl import Workbook

# 读取和解析JSON数据
with open('data_cache.json', 'r') as file:
    data = json.load(file)

# 创建一个新的Excel工作簿
wb = Workbook()
ws = wb.active

# 设置列标题
ws.append(["ID", "日期"])

# 遍历数据，将每一项添加到Excel中
for id, date in data.items():
    ws.append([id, date])

# 保存Excel文件
wb.save("上传日期篡改揭露总表.xlsx")