Excel Hidden Sheets & Rows Inspector
Excel Hidden Sheets & Rows Inspector: Inspects `workbook.xml` `<sheet state="hidden"/>` attributes and row definitions with `hidden="1"`.
About this excel hidden sheets & rows inspector
Excel Hidden Sheets & Rows Inspector — browser-based utility.
How this tool works
Implements client-side Excel Hidden Sheets & Rows Inspector operations. Inspects `workbook.xml` `<sheet state="hidden"/>` attributes and row definitions with `hidden="1"` specifically designed for a business negotiator checks an excel spreadsheet for hidden sheets, hidden rows, and invisible formulas before signing.
- OpenXML ZIP Decompression: Unpacks DOCX/PPTX archive structures in memory via fflate, validating package integrity against Zip Bomb attacks.
- XML DOM Parsing & Relationship Mapping: Parses word/comments.xml and word/_rels/document.xml.rels to resolve comment ranges, authors, and dates.
- Thread & Status Reconstruction: Reconstructs parent-child reply relationships and resolved states from commentsExtended parts.
- XLSX Workbook Compilation: Compiles parsed records into a typed Excel workbook with frozen header rows and auto-filters.
Worked example
Scenario: An auditor checks workbook metadata for a hidden sheet without changing the file.
Sample input:
Processing: Reads SheetJS workbook metadata, selects sheets whose Hidden flag is truthy, and includes defined names.
Illustrative output:
Limits and verification
Legacy binary formats (.doc, .ppt, .xls) must be converted to modern OpenXML (.docx, .pptx, .xlsx) before processing. Password-encrypted Office packages must be unlocked prior to parsing.
Examples demonstrate an expected workflow; they do not prove every input or every branch of an external specification. Check important results with an independent source before using them for money, security, compliance, safety, or irreversible file changes.
Browser processing boundary
Tool input is processed by code running in the browser and is not intentionally sent to a CZOA processing API. The page can still request ordinary site assets, analytics, or advertising when those services are enabled. Browser extensions and managed-device software remain outside this tool's control.
Relevant references
These references govern or help explain the format, protocol, or calculation used here. Listing a reference does not claim certification or complete implementation of every optional feature.
Content owner: CZOA Tools · Last reviewed: 2026-09-15 · Review methodology
How to use it
- Enter, paste, or select your input data into the Excel Hidden Sheets & Rows Inspector workspace controls.
- Review available parameter fields, units, formats, or options configured for your task.
- Click the action button or observe immediate live calculations rendered in your browser runtime.
- Inspect the resulting output and any diagnostic messages, then copy or download the result if needed.
Frequently asked questions
How does XLSX Hidden Data Inspector report a workbook?+
It reads selected bytes with SheetJS and returns JSON with workbook.SheetNames, workbook.Workbook.Sheets entries whose Hidden value is truthy, and workbook.Workbook.Names. It does not inspect rows, columns, cells, or formulas.
What controls and output are available?+
The page has one local file chooser and Process locally. There are no filters, unhide actions, edit controls, download, row scan, column scan, or formula scan; the result is read-only JSON.
What hidden-state limits apply?+
Only SheetJS workbook metadata determines hiddenSheets. The output lists sheet names and defined names when present; it does not distinguish hidden from veryHidden textually, verify protection, or prove that no other hidden content exists.
What did isolated browser verification establish?+
For an independently created XLSX with Public and hidden Internal sheets plus the LocalTotal defined name, the JSON is expected to list both sheets, hiddenSheets [Internal], and LocalTotal among definedNames. This checks workbook metadata only, not rows, cells, formulas, or protection.