For the complete documentation index, see llms.txt. This page is also available as Markdown.

Excel

Excel workbook test repository adapter for ABAP Agent 2.0 — CLI and Guides references.

Use adapter type excel when your test inventory lives in an Excel workbook on the agent host.

Configure

testrepo set parameters for excel

Non-secret keys use --setting key=value. Excel has no secrets. Plus common options (--name, --type, --pipeline, --test-stage) — see Configure Test Repositories.

Parameter
Kind
Required
Description

filePath

Setting

Yes

Path to the Excel workbook on the agent host (.xlsx, .xlsm, or .xls).

sheetName

Setting

Yes

The worksheet name that contains the test case data.

testCaseIdColumn

Setting

Yes

Column address for the test case ID (for example A).

testCaseNameColumn

Setting

Yes

Column address for the test case name (for example B).

searchColumns

Setting

Yes

Comma-separated column addresses to search for ABAP object matches (at least one required).

testCasePathColumn

Setting

No

Column address for the test case path.

searchPaths

Setting

No

Comma-separated list that scopes the search to specific paths. Written as top-level searchpaths in config.toml.

confidenceThreshold

Setting

No

Integer 0–100. Minimum confidence for a match.

Command
slabapcli.exe testrepo set --name "ALM_Demo-excel" --type "excel" --pipeline "ALM_Demo-S21" --setting filePath=C:\repos\testcases.xlsx --setting sheetName=TestCases --setting testCaseIdColumn=A --setting testCaseNameColumn=B --setting searchColumns=C,D --test-stage "Regression Tests"
Command
.\slabapcli.exe testrepo set --name 'ALM_Demo-excel' --type 'excel' --pipeline 'ALM_Demo-S21' --setting filePath=C:\repos\testcases.xlsx --setting sheetName=TestCases --setting testCaseIdColumn=A --setting testCaseNameColumn=B --setting searchColumns=C,D --test-stage 'Regression Tests'

--test-stage is optional. See Configure Test Repositories for the default "{type} Tests" value, clear-on-omit behavior, and duplicate-stage warning.

Excel has no interactive secrets.

Once the test repository is configured and the connection test succeeds:

  1. Finish any remaining agent setup for the pipeline (RFC, pipeline, additional test repositories) if you have not already.

  2. Schedule repository search with search_testrepo.

  3. Capture coverage with Footprints and your test runs.

For the full setup order, see Start the ABAP Agent Server and Configure Test Repositories.

search_testrepo registers a Windows Scheduled Task that runs watcher.exe SEARCH_TESTREPO on a cron schedule.

Parameter
Required
Description

--pipeline

Yes

Pipeline name ([[pipeline]].name).

--testrepo

Yes

Test repository name ([[testrepo]].name) linked to that pipeline.

--cron

No

5-field cron expression. Default: 0 2 * * 0 (Sunday at 02:00).

Full command reference (stop, list, prerequisites): Search Test Repositories.

SeaLights associates test executions with ABAP code changes through Footprints on the agent side.

1

Schedule Footprints for the pipeline

This creates a FOOTPRINTS scheduled task that periodically collects coverage-related data and sends it to SeaLights. Full syntax and stop command: Collect Footprints data for your Pipeline.

2

Run tests against the QAS system

Execute tests that exercise the ABAP components you care about while Footprints is collecting. The agent matches executed ABAP components against objects in the latest Build Modification and reports them as footprints.

3

Wait for processing, then check the Coverage Report

SeaLights needs time to process Footprints data. When processing completes, covered ABAP components appear in your application's Coverage Report.

Last updated

Was this helpful?