SoaTest CLI - Excel Data Source - Running Specific Sheet

GambitGambit Posts: 28
edited January 2018 in SOAtest

Good morning,

I am attempting to create a SOATest CLI command to execute a .tst and utilize one excel spreadsheet as my data source. When looking through the Parasoft 9.10.3 documentation (pages 75-80) I don't see a command listed to specify a specific spreadsheet. Is there such a command?

No spreadsheet option in CLI?: (This is the closest command I could find)

Spreadsheet option in GUI: (Dropdown)



  • jakubiakjakubiak Posts: 738 admin

    You simply set up your data source to use the sheet you want to use, and the CLI will automatically use that sheet when it uses that data source.

  • surajjaldusurajjaldu Posts: 2

    I would like to use the same test with different excel spreadsheets. I don't want to create multiple tst files just for the sake of data sheet. How do I pass the data sheet path as a variable in the command line arguments? or is there any other simple way to parameterize the spreadsheet path.

  • Ireneusz SzmigielIreneusz Szmigiel Posts: 219 ✭✭✭

    You can parametrize File Path with variables from environment, for example:

    You can switch environment definition which contains proper path definition with command line option:
    -environment <environment_name>

    You can use single Environment defintion, but you can change values of variables using options -dataGroupConfig and -environmentConfig

    Al those options you can find in manual

    Or just simply replace Excel file with new, before you start tests.

    Ireneusz Szmigiel

  • surajjaldusurajjaldu Posts: 2

    @Ireneusz Szmigiel, Thanks for your reply. I kind of figured that out from the manuals. Now, I am trying to figure out how to parameterize the sheet name.

Sign In or Register to comment.