name: multi-file-excel-parquet-analysis description: "读取多 Sheet Excel 文件并统计规模，支持大文件向 Parquet 格式转换、分类数据统计及可视化报告生成。"
Note: This sub-skill covers one step of the Excel analysis workflow. For the full pipeline (file reading, row counting, large-file optimization, export), see the parent workflow SKILL.md.
Step1 读取 Excel 文件，遍历所有 Sheet 统计行数，评估数据规模。
import pandas as pd
import os
file_path = "input_data.xlsx" # 替换为实际文件路径
if not os.path.exists(file_path):
print(f"Error: 文件 {file_path} 不存在")
else:
# 获取所有 sheet 名称
xl = pd.ExcelFile(file_path)
sheet_names = xl.sheet_names
print("Sheet 列表:", sheet_names)
total_rows = 0
for sheet in sheet_names:
# 仅读取第一列以快速统计行数，避免大文件内存溢出
df_tmp = pd.read_excel(file_path, sheet_name=sheet, usecols=[0])
row_count = len(df_tmp)
total_rows += row_count
print(f"Sheet: {sheet}, 行数: {row_count}")
print(f"总行数汇总: {total_rows}")