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 [('数据源_CF小合并', [38,39,40,41,42,45,46,47,48,49,50,51,54,55,57,58,60,61,64,68], range(1,8)), ('dm',[25,26,27,28,33,34,35,36,37,42,43,44,45,46,47,48,51], range(1,3))]:
    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))