import openpyxl, json
from pathlib import Path
p=Path('/Users/neo/.hermes/cache/documents/doc_1d136388d7ce_wanchuan_anhui_v9_v2_1_long_asset_R29_R169_asset_schedule_atomic_EXCEL_REPAIR_SAFE_20260513-094726v1.xlsx')
wbv=openpyxl.load_workbook(p,data_only=True,read_only=True)
wbf=openpyxl.load_workbook(p,data_only=False,read_only=True)
wsn='长期资产循环_全量穿透校验'
wv=wbv[wsn]; wf=wbf[wsn]
cols=list('ABCDEFGHIJKLMN')
for r in range(61,181):
    vals=[]
    nonempty=False
    for c in cols:
        cv=wv[f'{c}{r}'].value
        cf=wf[f'{c}{r}'].value
        if cv is not None or cf is not None:
            nonempty=True
        # concise display: prefer formula if exists, else value
        disp=cf if cf is not None else cv
        if isinstance(disp,float):
            disp=f'{disp:,.2f}'
        vals.append(disp if disp is not None else '')
    if nonempty:
        print(f'R{r:03d} | ' + ' | '.join(str(x).replace('\n',' / ')[:80] for x in vals))