Excel

Wetator supports Microsoft Excel files (both .xls and .xlsx) as a convenient way to write and maintain test cases using a spreadsheet layout. The Excel format is especially useful for non-technical team members who prefer a tabular view of test steps.

File structure

Each row in the spreadsheet represents one test step. The columns are used as follows:

  • Column A — optional comment for the step (displayed in the report)
  • Column B — the command name (e.g. open-url, assert-content)
  • Column C — the first parameter (e.g. the URL or WPath)
  • Column D — the second (optional) parameter (e.g. the value to set)

Empty rows are ignored. A template file empty.xls is included in the Wetator distribution under the templates directory.

A simple test script might look like this

Comment Command Parameter Optional Parameter
open-url https://www.wetator.org/testform
assert-title WETATOR / Test Form
assert-content The form below is only for testing purpose
set Project name My Fancy Web App Under Test
select JAVA
click-on Submit My Truth
assert-content Thank you for submitting your truth about WETATOR

Comments

If you like to add a comment, leave the command column (column B) empty and place the comment text in the first parameter column (column C). Alternatively, use the describe command to add a Markdown-formatted description that will appear in the test report.

Disabled commands

To disable (skip) a command without removing it, prefix the command name with '#', e.g. #click-on.