🚀 How to Build a Playwright Framework with Excel Data-Driven Testing

Modern test automation requires scalability, reusability, and flexibility.
In this guide, we’ll build a Playwright automation framework that supports:

• ✅ Data-driven testing using Excel (ExcelJS)
• ✅ Clean Page Object Model (POM) structure

---

🧠 Why Data-Driven Testing?

Instead of hardcoding test data, we store it in an Excel file and dynamically run tests with multiple inputs.

📌 Use Cases:

• Login testing with multiple users
• Form validation
• Regression testing
• API + UI test combinations

---

⚙️ Tech Stack

• Playwright (E2E automation)
• Node.js
• ExcelJS (Excel handling)

---

📂 Project Structure

PlayWrightAutomation/
│
├── tests/                # Test cases
├── pages/                # Page Object Models
├── utils/                # Excel utilities
├── test-data/            # Excel test data
├── playwright.config.js
├── package.json

---

📊 Step 1: Create Excel Test Data

Example (testData.xlsx):

username	password
user1	pass1
user2	pass2

---

🔧 Step 2: Read Excel Data using ExcelJS

Create utils/excelUtil.js:

const ExcelJS = require("exceljs");

async function getExcelData(sheetName) {
    const workbook = new ExcelJS.Workbook();
    await workbook.xlsx.readFile("./test-data/testData.xlsx");

    const worksheet = workbook.getWorksheet(sheetName);
    const data = [];

    let headers = [];

    worksheet.eachRow((row, rowNumber) => {
        if (rowNumber === 1) {
            headers = row.values;
        } else {
            let rowData = {};
            row.eachCell((cell, colNumber) => {
                rowData[headers[colNumber]] = cell.value;
            });
            data.push(rowData);
        }
    });

    return data;
}

module.exports = { getExcelData };

---

🧪 Step 3: Use Data in Playwright Tests

const { test } = require('@playwright/test');
const { getExcelData } = require('../utils/excelUtil');

test.describe("Data Driven Tests", () => {

    let testData;

    test.beforeAll(async () => {
        testData = await getExcelData("Sheet1");
    });

    for (const data of testData) {
        test(`Login Test - ${data.username}`, async ({ page }) => {
            await page.goto("https://example.com");

            console.log("Testing with:", data.username, data.password);
        });
    }
});

---

⚡ Step 4: Run the Tests

npm install
npx playwright test

---

📊 Step 5: View HTML Report

npx playwright show-report

📌 Report Includes:

• Passed / Failed tests
• Execution time
• Logs

---

⚙️ Advanced Configuration (Coming Soon 🚧)

To make this framework production-ready, upcoming features include:

• 📱 Mobile device emulation (viewport)
• 🎥 Screenshots, videos & trace debugging
• 🔐 SSL handling & environment configs
• 🤖 AI-assisted debugging

👉 These will upgrade the framework to a production-grade solution

---

🔄 CI/CD Integration (Coming Soon 🚧)

• GitHub Actions setup
• Automated test execution on push
• Report publishing

---

🔥 Key Benefits

• Scalable test design
• Easy test data management
• Reusable POM structure
• Real-world automation ready

---

🔗 Full Source Code

👉 https://github.com/ankitaloni369/PlayWrightAutomation

---

🎯 Conclusion

Combining Playwright with Excel-based data-driven testing enables you to build a powerful, scalable automation framework.

---

⭐ Support

If you found this useful, consider giving the repo a ⭐ and sharing it!