import openpyxl
from pathlib import Path
p=Path('/Users/neo/.hermes/audits/cashflow-asset-hook-20260512-083049/wanchuan_anhui_v9_v2_1_long_asset_R29_R58_asset_class_atomic_SAFE_20260513-085849.xlsx')
wb_f=openpyxl.load_workbook(p,data_only=False)
wb_v=openpyxl.load_workbook(p,data_only=True)
for sh, ranges in [('现金流量表底稿',[(180,205),(238,251),(408,424)]),('资产减值明细表',[(1,30)]),('附注',[(680,695),(1020,1070),(1220,1250)]),('试算表',[(20,25),(50,75)])]:
    ws=wb_f[sh]; wsv=wb_v[sh]
    print('\n==',sh,'==')
    for a,b in ranges:
        for r in range(a,b+1):
            vals=[]
            for c in range(1,min(ws.max_column,12)+1):
                v=ws.cell(r,c).value; vv=wsv.cell(r,c).value
                if v is not None or vv is not None:
                    if isinstance(v,str) and v.startswith('='):
                        vals.append(f'{ws.cell(r,c).coordinate}={v}->{vv}')
                    else:
                        vals.append(f'{ws.cell(r,c).coordinate}={v if v is not None else vv}')
            if vals: print('ROW',r,' | '.join(vals))