xlsx_protection
Identify locked cells, sheets, and workbook settings in .xlsx files to avoid editing protected content. Audit which cells are fillable before suggesting changes.
Instructions
Surface every protection setting in a LOCAL .xlsx file so an agent knows what it can and cannot edit. Workbook-level (lockStructure, lockWindows), per-sheet (protected? password? hidden state?), per-action allow/block list (formatCells, sort, insertRows, pivotTables, etc.), and per-cell unlocked / hidden samples — these are the cells a human would actually be allowed to type into when the sheet is otherwise read-only.
Reads sheetProtection action attrs directly from the OOXML zip (workaround for ExcelJS stripping them on round-trip).
USE WHEN: an agent is about to suggest edits and you want to fail fast on cells / sheets the user can't change anyway. Or auditing a "submitted form" workbook to see which inputs the author intended fillable.
DO NOT USE WHEN: just reading values (use xlsx_read). Or trying to BREAK protection (this surfaces what's locked; it does not unlock).
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| file_b64 | Yes | ||
| options | No |