📋Excel Result Reports

Abstract

OMrun handles two modes how to create Excel Result Sheets:

  1. Running a batch job with reporting definition or

  2. Manual creating an Excel Report based on the actual viewed results (Scenario, Parameter List, Test Objects)

The result data is taken from the OMrun result grid 1:1, exactely as it was shown on the OMrun result grid when exported or as defined in the batch definition during test execution. Also the background color of each cell is inherited from the original test results.


Scenario Results

The result Excel sheet is an exact copy including values and background color of the cells from the result grid shown in the OMrun tool.

The scenario Excel result sheet is generated automatically when running a batch job where reporting is configured.

Using the Button Export if a scenario tab is open and activated, the actual presented result is exported to Excel.

Excel file name TSC.\<environment name>.\<scenario name>.\<DateTime\[YYYY-MM-DD\_hh-mm-ss]>.xlsx


Parameter Results

The result Excel sheet is an exact copy including values and background color of the cells from the result grid shown in the OMrun tool.

The parameter list Excel result sheet is generated manually only. Using the Button Export if a parameter list tab is open and activated, the actual presented result is exported to Excel.

Excel file name PML.\<environment name>.\<component name>.\<object name>.\<parameter list name>.\<id no>.\<DateTime\[YYYY-MM-DD\_hh-mm-ss]>.xlsx


Excel Test Object Results

The result Excel sheet is an exact copy including values and background color of the cells from the result grid shown in the OMrun tool.

The data test object Excel result sheet is generated automatically when running a batch job where reporting is configured. Program test objects are not generated automatically as the only contain one row passed or failed of the methode executed. It can be generated manually only.

Using the Button Export if a test object tab is open and activated, the actual presented result is exported to Excel.

Excel file name TOB.\<environment name>.\<component name>.\<object name>.\<parameter list name>.\<id no>.\<DateTime\[YYYY-MM-DD\_hh-mm-ss]>.xlsx


Info on Report

Top Left

Information about the reported test results:

  1. Test Object Results - Quote = Constant description

  2. Test Object Results - Quote = Scenario, Parameter List or Test Object

  3. Filter = "Passed", "Failed", "All"

  4. Row Limit (-1) = unlimited rows or row max. limit set to e.g. 1000

Top Right

Information about the reported test results:

  1. Test Execution Date (American format)

  2. Test Execution Time

Bottom Center

Information about the reported test results:

Result Filename of:

  • Scenario or

  • Parameter List or

  • Test Object

Last updated