import pandas as pd

df = pd.read_excel(r'D:\project\caiwu\rijizhang\中行HISXLS-20260128-20260129-0804715541775272430.xls', header=8)
print('数据行数:', len(df))
print('\n关键字段数据:')
for i in range(len(df)):
    print(f'\n行{i}:')
    print(f'  交易类型: {df.iloc[i]["交易类型[ Transaction Type ]"]}')
    print(f'  收款人名称: {df.iloc[i]["收款人名称[ Payee\'s Name ]"]}')
    print(f'  收款人开户行名: {df.iloc[i]["收款人开户行名[ Beneficiary account bank ]"]}')
    print(f'  摘要: {df.iloc[i]["摘要[ Reference ]"]}')
    print(f'  交易金额: {df.iloc[i]["交易金额[ Trade Amount ]"]}')