import pandas as pd df = pd.read_excel(r'C:\Users\EDY\Desktop\日记账\橙风-农行-账户明细查询列表 (3).xls', header=2) print('所有列名:') for i, col in enumerate(df.columns): print(f'{i}: {col}') print('\n前20行数据:') print(df.head(20))