# 例: 月次実績シート → 取締り会向けスライドの表を更新
from pathlib import Path
from openpyxl import load_workbook
from pptx import Presentation

def sync_kpi_table(xlsx: Path, pptx_in: Path, pptx_out: Path) -> None:
    wb = load_workbook(xlsx, data_only=True)
    ws = wb["KPI"]
    kpi_rows = [[c.value for c in row] for row in ws.iter_rows(min_row=2, max_row=8)]

    prs = Presentation(pptx_in)
    table = prs.slides[2].shapes[5].table  # テンプレ上の位置は固定
    for r, row in enumerate(kpi_rows):
        for c, val in enumerate(row):
            table.cell(r + 1, c).text = str(val if val is not None else "")

    prs.save(pptx_out)
    print(f"saved: {pptx_out}")