multi-file-excel-parquet-analysis

Read multi-sheet Excel files, count rows per sheet, and export Parquet reports.

110|3|Updated Feb 26, 2026
One-click install
npx skills add https://github.com/MichaelYang-lyx/AIDABench --skill multi-file-excel-parquet-analysis-michaelyang-lyx
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: multi-file-excel-parquet-analysis
Source: https://github.com/MichaelYang-lyx/AIDABench/tree/main/skills/sn-da-excel-workflow/capability/excel-reading/multi-file-reading
Command: npx skills add https://github.com/MichaelYang-lyx/AIDABench --skill multi-file-excel-parquet-analysis-michaelyang-lyx

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

读取多 Sheet Excel 文件并统计数据规模,支持将大文件转换为 Parquet 格式、进行分类统计,并生成可视化报告。

Core Features & Use Cases

  • 逐 Sheet 统计行数与总规模,适用于大数据量的 Excel 数据洞察。
  • 将大型工作簿转换为 Parquet,以提高后续分析的性能与存储效率。
  • 进行分类统计与占比分析,并输出可下载的统计报告和图表。

Quick Start

使用该技能对包含多 Sheets 的 Excel 文件执行读取、统计与导出 Parquet 与可视化报告的快速分析。

Frequently Asked Questions about multi-file-excel-parquet-analysis

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I count rows across multiple sheets in a large Excel file?

To count rows across multiple sheets in a large Excel file, this Skill reads each sheet individually and aggregates per-sheet row counts to estimate the total dataset size. It handles multi-sheet workbooks robustly for large-scale data analytics.

How do I convert an Excel workbook to Parquet format for better performance?

You can convert an Excel workbook to Parquet format to improve subsequent analysis performance and storage efficiency. This Skill directly ingests the Excel data and exports it as Parquet files for optimized downstream workflows.

Can I generate a visualization report directly from Excel data?

Yes, you can generate a visualization report directly from Excel data. This Skill performs categorization, calculates statistics, and outputs downloadable statistical reports alongside charts for large Excel datasets.

Does this Excel analysis approach work for estimating dataset size before Parquet export?

Yes, this approach works for estimating dataset size before Parquet export. It enumerates every sheet to calculate total row counts, providing a clear estimate of data scale prior to format conversion and visualization.

What is the best way to handle categorization and percentage analysis for Excel data?

The best way to handle categorization and percentage analysis for Excel data is using an end-to-end workflow. This Skill ingests the workbook, calculates category statistics, and generates a report with proportion analysis.

Are there limitations when reading multi-sheet Excel files for Parquet conversion?

While robust input handling is implemented, limitations depend on the structure of the multi-sheet Excel files being read. Extremely complex or irregular sheets may affect the accuracy of row enumeration and subsequent Parquet conversion.