skills.rest
cjrain-12505614
cjrain-12505614COMMUNITY
Explore all skills by this author →
GitHub

solo-excel-reviewer

Inspect Excel workbook structure including hidden sheets, merged cells, and data validations.

Updated Apr 23, 2026
Search Tags:#data validation#openpyxl#excel#xlsx#workbook inspection#merged cells#hidden sheets
One-click install
npx skills add https://github.com/cjrain-12505614/solo-forge-marketplace --skill solo-excel-reviewer-cjrain-12505614
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: solo-excel-reviewer
Source: https://github.com/cjrain-12505614/solo-forge-marketplace/tree/main/solo-forge-v1.2.0/skills/solo-excel-reviewer
Command: npx skills add https://github.com/cjrain-12505614/solo-forge-marketplace --skill solo-excel-reviewer-cjrain-12505614

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires openpyxl.

What problem does it solve? Excel workbooks often hide critical context in hidden sheets, merged cells, and dropdown validations that a quick glance at visible cells misses. This Skill performs a full structural inspection of .xlsx/.xlsm files so nothing important is overlooked. ## Core Features & Use Cases - Full Metadata Inspection: Lists every sheet with its visibility state, dimensions, merged cell count, and data validation count using openpyxl. - Hidden Content Detection: Separately reports hidden sheets, hidden rows, and hidden columns so buried context is never missed. - Zip/XML Fallback: When openpyxl parsing fails, it falls back to reading the raw zip/XML structure to recover at least the sheet list and hidden states. - Use Case: A QA scenario or WBS arrives as an Excel file. Run this Skill to discover a hidden sheet containing acceptance criteria and merged header structures before writing any plan. ## Quick Start Analyze the structure of the attached Excel workbook and list all sheets including any hidden ones, merged cells, and dropdown validations.

Frequently Asked Questions about solo-excel-reviewer

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

FAQPage Schema
How do I find hidden sheets in an Excel file with Python?▼

Load the workbook with openpyxl and check each worksheet's sheet_state property, which returns visible, hidden, or veryHidden. Listing all sheets with their states reveals tabs that the Excel UI may not show.

How to inspect merged cells and data validations in xlsx files?▼

Use openpyxl's ws.merged_cells.ranges for merged regions and ws.data_validations.dataValidation for dropdown rules. Counting these per sheet shows which sheets rely on structural formatting or constrained inputs.

What to do when openpyxl fails to parse an Excel file?▼

An .xlsx file is a zip archive, so you can fall back to unzip -l and read xl/workbook.xml and xl/worksheets/*.xml directly. This recovers at least the sheet list, hidden states, and presence of merges or validations.

Does openpyxl support .xlsm macro-enabled workbooks?▼

Yes, openpyxl can open .xlsm files when loaded with keep_vba=True, preserving the VBA project while exposing sheet structure. It reads structure and cell values but does not execute macros.

Why does Excel parsing show incomplete cell values?▼

Values can be incomplete when formulas are not cached, sheets use heavy merging, or the file is partially corrupt. In those cases, request a CSV re-export or a screenshot of the specific sheet for accurate interpretation.

Related Skills

Explore More Data & Analytics Skills→
PostalocityPostalocity
1

xlsx

Clean, transform, and generate .xlsx workbooks from .xlsx, .xlsm, .csv, and .tsv inputs.

Official
Intermediate
jcg-adminjcg-admin

pm-planning

Develops PMBOK project management plans with WBS, CPM schedules, cost baselines, and risk registers.

Community
Intermediate
JYeswakJYeswak

sheets-reconciliation

Compare a sheet range against its source of truth and report mismatches with cell-level citations.

Community
Intermediate
dp-archivedp-archive
1.1k

spreadsheet

Automate spreadsheet creation, editing, analysis, and formatting for .xlsx, .csv, and .tsv files.

Community
Intermediate