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 [('长期资产循环校验_公式明细 (2)', range(125,137), range(1,12)), ('试算表', [42,54,57,61,66,70,71,75,17,20,21,22,23,24,28], range(1,27)), ('附注', [364,689,691,756,1022,1029,1030,1031,1051,1067,1205,1224,1239,1244], range(1,10)), ('固定资产',[7,8,15,30,37,53,54,57], range(1,9)), ('在建工程情况表',[24], range(1,18)), ('无形资产变动表',[7,15,27,33,46,47,50], range(1,10)), ('投资性房地产',[8,15,29,35,50,51,54], range(1,5)), ('使用权资产 ',[7,9,12,21,23,26,36], range(1,8)), ('长期待摊费用变动明细表',[17], range(1,13)), ('长期应付款明细',[23], range(1,9))]:
    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))