Agent skill

xlsx-check-for-errors

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

Stars 4
Forks 4

Install this agent skill to your Project

npx add-skill https://github.com/vamseeachanta/workspace-hub/tree/main/.claude/skills/_archive/data/documents/xlsx/check-for-errors

SKILL.md

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

Expand your agent's capabilities with these related and highly-rated skills.

Didn't find tool you were looking for?

Be as detailed as possible for better results