vamseeachanta Check for Errors (+1)
Check for Errors
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:
- Check cell references are correct
- Avoid off-by-one errors
- Test edge cases (empty cells, zeros)
- Verify formula logic