AiDOPWarehouse/ai-dop-platform/tools/_dump_time_sheet.py

# -*- coding: utf-8 -*-
import json
import openpyxl
from openpyxl.utils import get_column_letter

p = r"d:\Projects\Ai-DOP\AI-DOP项目总计划_20260413.xlsx"
wb = openpyxl.load_workbook(p, data_only=True)
ws = wb["每周详细计划_时间"]
rows = []
for r in range(1, ws.max_row + 1):
    row = {get_column_letter(c): ws.cell(r, c).value for c in range(1, 9)}
    if any(v is not None and str(v).strip() for v in row.values()):
        rows.append({"r": r, **{k: v for k, v in row.items() if v is not None and str(v).strip()}})
merges = [str(m) for m in ws.merged_cells.ranges]
with open(r"d:\Projects\Ai-DOP\SourceCode\ZZYDOP\ai-dop-platform\tools\_time_dump.json", "w", encoding="utf-8") as f:
    json.dump({"merges": merges, "rows": rows}, f, ensure_ascii=False, indent=2)
print("ok", len(rows))