# Excel Result Reports

### ![](https://2873353689-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FfK1YJaTCqOiS0L22wVKG%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/version-4.x/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://2873353689-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FfK1YJaTCqOiS0L22wVKG%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/version-4.x/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://2873353689-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FfK1YJaTCqOiS0L22wVKG%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/version-4.x/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://2873353689-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FfK1YJaTCqOiS0L22wVKG%2Fuploads%2Fgit-blob-675ec1a499f752463f75472e289db644b1664338%2FOMrunHelp_ExcelResults3.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://2873353689-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FfK1YJaTCqOiS0L22wVKG%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://2873353689-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FfK1YJaTCqOiS0L22wVKG%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://2873353689-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FfK1YJaTCqOiS0L22wVKG%2Fuploads%2Fgit-blob-e2b2cef55c56d027abc75d660362df8892c12538%2FOMrunHelp_ExcelResults6.gif?alt=media" alt="Excel report: bottom center"><figcaption><p>Excel report: bottom center</p></figcaption></figure>


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://dbi-services.gitbook.io/omrun-help/version-4.x/result-analysis/excel-result-reports.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.