from pathlib import Path
import openpyxl
p=Path('/Users/neo/.hermes/cache/documents/doc_259cbd37e734_万传安徽_V9_v2.1_R66拆3sub+12sub行全拆开_20260512.xlsx')
wbf=openpyxl.load_workbook(p,data_only=False,read_only=False,keep_links=True)
wbv=openpyxl.load_workbook(p,data_only=True,read_only=False,keep_links=True)
for sheet, rows, cols in [('试算表', range(38,76), range(1,9)), ('附注', range(360,366), range(1,8)), ('数据源_CF小合并', [38,39,40,41,51,52,53,54,55,56,58,59,60,63,64,65,67,68,69], range(1,8))]:
    print('\n###', sheet)
    wsf=wbf[sheet]; wsv=wbv[sheet]
    for r in rows:
        vals=[]
        for c in cols:
            f=wsf.cell(r,c).value; v=wsv.cell(r,c).value
            if f is not None or v is not None:
                vals.append(f'{wsf.cell(r,c).coordinate}:F={f!r}|V={v!r}')
        if vals:
            print('ROW',r,' || '.join(vals))
