#!/usr/bin/env python3
"""Show where 0x80, 0x81, 0x82 come from - from both xlsx files."""
import openpyxl

print("=" * 70)
print("来源 1: MCU-ARM_v2.xlsx → update sheet")
print("=" * 70)
wb = openpyxl.load_workbook(
    '/Users/admin/workspace/jyq/qsjnic/docs/MCU_ARM_Reference/MCU-ARM_v2.xlsx',
    read_only=True, data_only=True
)
ws = wb['update']
for i, row in enumerate(ws.iter_rows(values_only=True)):
    row_num = i + 1
    non_empty = [(j, str(v)[:80]) for j, v in enumerate(row) if v is not None]
    if non_empty:
        cmd = row[0] if row[0] else ''
        if '0x80' in str(cmd) or '0x81' in str(cmd) or '0x82' in str(cmd) or '0x83' in str(cmd):
            print(f'\nRow {row_num}:')
            for col, val in non_empty:
                print(f'  Col{col}: {val}')
wb.close()

print("\n" + "=" * 70)
print("来源 2: MCU升级-Update.xlsx → Update sheet")
print("=" * 70)
wb = openpyxl.load_workbook(
    '/Users/admin/workspace/jyq/qsjnic/docs/MCU_ARM_Reference/MCU升级-Update.xlsx',
    read_only=True, data_only=True
)
ws = wb['Update']
for i, row in enumerate(ws.iter_rows(values_only=True)):
    row_num = i + 1
    row_data = [str(v)[:100] for v in row]
    line = ' | '.join(row_data).strip()
    if '80h' in line or '81h' in line or '82h' in line or '83h' in line:
        non_empty = [(j, str(v)[:80]) for j, v in enumerate(row) if v is not None]
        print(f'\nRow {row_num}:')
        for col, val in non_empty:
            print(f'  Col{col}: {val}')
wb.close()