tanqiu/assets/resources/data/excel/check_weapon_excel.py

import pandas as pd
import os

# 检查武器配置Excel文件
file_path = '方块武器配置/方块武器配置表.xlsx'

if os.path.exists(file_path):
    xl = pd.ExcelFile(file_path)
    print('工作表列表:', xl.sheet_names)
    
    for sheet in xl.sheet_names:
        print(f'\n=== 工作表: {sheet} ===')
        df = pd.read_excel(file_path, sheet_name=sheet)
        print(f'形状: {df.shape}')
        print(f'列名: {list(df.columns)}')
        print('前5行数据:')
        print(df.head())
        print('\n')
else:
    print(f'文件不存在: {file_path}')