Skip to main content

Excel Templates

Chathai uses Excel templates to generate Cypress test scripts. Here you'll find information about the template structure and how to customize it for your needs.

Default Template Structure

The default template includes the following columns:

  • Test Case ID - Unique identifier for the test case
  • Test Case Name - Descriptive name of the test case
  • Description - Detailed description of what the test case does
  • Steps - Step-by-step instructions for the test
  • Expected Result - What should happen when the test runs
  • Actual Result - What actually happened during test execution
  • Status - Current status of the test case (Pass/Fail/Blocked)

Customizing Templates

You can customize the template by:

  1. Creating your own Excel file with the required columns
  2. Using the --template option when running the generate command
  3. Modifying the column structure to match your testing needs

Template Best Practices

  • Keep test case IDs unique and meaningful
  • Write clear and concise test case names
  • Include detailed steps that can be automated
  • Specify exact expected results
  • Use consistent formatting throughout the template

Example Template

Test Case ID | Test Case Name | Description | Steps | Expected Result | Actual Result | Status
TC001 | Login Valid | Verify login with valid credentials | 1. Enter username
2. Enter password
3. Click login | User should be logged in | - | Pass
TC002 | Login Invalid | Verify login with invalid credentials | 1. Enter invalid username
2. Enter invalid password
3. Click login | Error message should be displayed | - | Fail