Playwright Excel Integration

Overview

Convert Playwright codegen scripts into Excel-driven automations with centralized config and required MCP validation.

Environment

• Use the playwright conda environment.
• Before running any Python command, run: conda run -n playwright python -c "import sys; print(sys.executable)"
• Do not create or activate any venv or .venv.

Inputs

• Playwright codegen script path
• Excel .xlsx path
• Mapping lines: "hardcoded_value" -> Excel[Sheet][FilterCol==FilterVal][DataCol]
• Optional override: PLAYWRIGHT_TARGET_SUBJECT

Workflow

1. Analyze the Playwright script and the Excel structure (sheets, columns, sample rows).
2. Detect hardcoded .fill() values and confirm that each has a mapping; request clarification for mismatches.