Relevant jobs
Product Manager
Backend Engineer
Data Analyst / Data Engineer
Admin & Office Secretary
huashu-excelalchaincyf/huashu-excel
Detects and removes summary rows such as "Total" and "East China Subtotal" that are mixed into Excel report data rows,…
No ratings yet
Rate this skill
Stars433
Forks65
Watchers433
Open Issues3
InstallOne-line install
UnconfirmedWhether this repository follows the Agent Skills spec (that is, whether it contains a SKILL.md) has not been verified yet. Until that is settled, clone it and use what you need:
git clone https://github.com/alchaincyf/huashu-excel.git
OverviewOverview
Key Features
Detects and removes summary rows such as "Total" and "East China Subtotal" that are mixed into Excel report data rows, preventing summary amounts from being mistaken for real business records. Key capabilities include: 1. Summary row detection: matches keywords like "Total", "Subtotal" and "Grand Total" in row labels and flags rows containing values such as 15,368,317 as summary rows rather than store records; 2. Subtotal level distinction: distinguishes regional subtotals like "East China Subtotal" from grand totals so the same amount is not double-counted in store statistics; 3. Clean output: outputs detail data with summary rows removed as a clean table ready for pivoting and aggregation.
Use Cases
Store sales report reconciliation, cleaning Excel files with mixed multi-level subtotals and totals, pre-processing before pivot tables, unifying detail-level figures in finance and operations reports.
Target Roles
Data Analyst / Data Engineer, Administrative / Clerical Staff, Product Manager (PM), Backend Developer.
RatingUser ratings
Nobody has rated this skill yet. Yours would be the first on the site — your vote becomes the initial average.
RepositoryRepository
| Skill ID | 1969 |
|---|---|
| Data source | GitHub |
| Repository | alchaincyf/huashu-excel |
| Category | AI & Agent Skills / Data Analysis & Spreadsheet Processing |
| Primary language | Python |
| License | MIT License |
| Default branch | master |
| GitHub repository ID | 1343411249 |
| Node ID | R_kgDOUBLUMQ |
| Rank | #1446 (position within the source ranking) |
| Site-wide popularity rank | #1638 (computed live from Stars, across all 5833 entries) |
GrowthStar / Fork growth
One snapshot per day, tracking how Stars and Forks changed
- Now433
- Previous point · 09-29 426
- vs previous point +7
- 2 data points 12 days
- Now65
- Previous point · 09-29 64
- vs previous point +1
- 2 data points 12 days
TimelineTimeline
Repository created2026-08-23 05:38:432 months ago
Data last updated2026-10-26 12:14:2623 days ago
Last commit2026-09-15 08:53:232 months ago
CommitLatest commit
Version [latest] committed by alchaincyf. Update Category: Bug Fixes & Stability Improvements. Commit details: fix(profile): CSV 的每一列都被误报成「数字被存成了文本」. This update resolves known runtime errors and enhances system reliability.