# Python Dependencies for Excel Template Generator
# 
# Install with: pip install -r requirements.txt
# Or use virtual environment: python3 -m venv .venv && source .venv/bin/activate && pip install -r requirements.txt

# Excel Generation
openpyxl>=3.1.0  # Excel generation with charts, pivot tables, sparklines, advanced formatting

# Data Manipulation (optional, for complex data processing)
pandas>=3.0.0  # Data manipulation and analysis (BREAKING: Copy-on-Write default, string dtype changes)

# Template Validation
jsonschema>=4.26.0  # JSON schema validation for template definitions (requires Python >=3.10)

# Testing Framework
pytest>=9.0.0  # Testing framework for Python scripts
pytest-cov>=4.1.0  # Coverage reporting for tests

# Code Quality
black>=23.0.0  # Code formatting
mypy>=1.5.0  # Type checking
flake8>=6.1.0  # Linting

# Utilities
python-dateutil>=2.8.2  # Date parsing and manipulation
PyYAML>=6.0  # YAML parsing (generate-rule-metadata.py, validate-rules)

# Web Scraping & Browser Automation
requests>=2.31.0  # HTTP library for API calls
beautifulsoup4>=4.12.0  # HTML parsing
playwright>=1.40.0  # Browser automation for dynamic content

# OG Image Generation
Pillow>=10.0.0  # WebP conversion, image validation