# XLSX Check For Errors

> Sub-skill of xlsx: Check for Errors (+1).

- Skill: `vamseeachanta/xlsx-check-for-errors` (Agent Skill)
- Install (CLI): `npx skillmds@latest add vamseeachanta/xlsx-check-for-errors`
- Raw SKILL.md: https://api.skillmd.com/api/skills/vamseeachanta/xlsx-check-for-errors/raw
- Safety review: PASS (external: skill-scanner PASS, skillspector PASS)
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Data & Analytics
- Author: vamseeachanta (https://skillmd.com/u/vamseeachanta)
- Updated: 2026-09-17
- Page: https://skillmd.com/skills/vamseeachanta/xlsx-check-for-errors

---


# Check for Errors (+1)

## Check for Errors


```python
from openpyxl import load_workbook

wb = load_workbook("model.xlsx", data_only=False)
ws = wb.active

errors = ["#REF!", "#DIV/0!", "#VALUE!", "#N/A", "#NAME?", "#NULL!", "#NUM!"]

for row in ws.iter_rows():
    for cell in row:
        if cell.value and isinstance(cell.value, str):
            for error in errors:
                if error in str(cell.value):
                    print(f"Error {error} in cell {cell.coordinate}")
```

## Validate Formulas


Before saving, always:
1. Check cell references are correct
2. Avoid off-by-one errors
3. Test edge cases (empty cells, zeros)
4. Verify formula logic