# Excel Result Reports

### ![](https://1143774439-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F1ooXfQ2qWGFRh6lihybt%2Fuploads%2Fgit-blob-bcd936488044444f9a82c5ec13aeba85e3ab44ec%2FButton_export.png?alt=media)

### 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](https://dbi-services.gitbook.io/omrun-help/menu-functions/button-export "mention") 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`

<figure><img src="https://1143774439-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F1ooXfQ2qWGFRh6lihybt%2Fuploads%2Fgit-blob-1c0af8947e94a95fa74d7f9f6f4e7d4148e2a8ef%2FOMrunHelp_ExcelResults1.gif?alt=media" alt="OMrun scenario result in Excel"><figcaption><p>OMrun scenario result in Excel</p></figcaption></figure>

***

### 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](https://dbi-services.gitbook.io/omrun-help/menu-functions/button-export "mention") 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`

<figure><img src="https://1143774439-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F1ooXfQ2qWGFRh6lihybt%2Fuploads%2Fgit-blob-03637e03f05003ce09f307569f2495e2c942ced0%2FOMrunHelp_ExcelResults2.gif?alt=media" alt="OMrun parameter list result in Excel"><figcaption><p>OMrun parameter list result in Excel</p></figcaption></figure>

***

### 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](https://dbi-services.gitbook.io/omrun-help/menu-functions/button-export "mention") 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`

<figure><img src="https://1143774439-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F1ooXfQ2qWGFRh6lihybt%2Fuploads%2Fgit-blob-675ec1a499f752463f75472e289db644b1664338%2FOMrunHelp_ButtonExport1.gif?alt=media" alt="OMrun test object result in Excel" width="80%"><figcaption><p>OMrun test object result in Excel</p></figcaption></figure>

***

### 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

<figure><img src="https://1143774439-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F1ooXfQ2qWGFRh6lihybt%2Fuploads%2Fgit-blob-8c01e32e1f8dc1a55b2d77c533fe08f04c490976%2FOMrunHelp_ExcelResults4.gif?alt=media" alt="Excel report: top left"><figcaption><p>Excel report: top left</p></figcaption></figure>

#### Top Right

Information about the reported test results:

1. Test Execution Date (American format)
2. Test Execution Time

<figure><img src="https://1143774439-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F1ooXfQ2qWGFRh6lihybt%2Fuploads%2Fgit-blob-ddd1ea78a2e08fec1f029d79faa228f70783fd55%2FOMrunHelp_ExcelResults5.gif?alt=media" alt="Excel report: top right"><figcaption><p>Excel report: top right</p></figcaption></figure>

#### Bottom Center

Information about the reported test results:

Result Filename of:

* Scenario or
* Parameter List or
* Test Object

<figure><img src="https://1143774439-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F1ooXfQ2qWGFRh6lihybt%2Fuploads%2Fgit-blob-e2b2cef55c56d027abc75d660362df8892c12538%2FOMrunHelp_ExcelResults6.gif?alt=media" alt="Excel report: bottom center"><figcaption><p>Excel report: bottom center</p></figcaption></figure>