#!/usr/bin/env python3
"""Extract protocol format details from MCU-ARM_v2.xlsx."""
import openpyxl

wb = openpyxl.load_workbook('/Users/admin/workspace/jyq/qsjnic/docs/MCU_ARM_Reference/MCU-ARM_v2.xlsx', read_only=True, data_only=True)

for sname in ['格式定义', 'MsgType定义', 'update', 'can', 'public']:
    if sname not in wb.sheetnames:
        print(f'[SKIP] sheet {sname} not found')
        continue
    ws = wb[sname]
    print(f'\n{"="*60}')
    print(f'=== Sheet: {sname} (rows={ws.max_row}, cols={ws.max_column}) ===')
    count = 0
    for row in ws.iter_rows(values_only=True):
        vals = [str(v) if v is not None else '' for v in row]
        line = ' | '.join(vals)
        if line.strip(' |'):
            print(line)
            count += 1
        if count > 120:
            print('  ... (truncated)')
            break
    print()

wb.close()