SoaTest CLI - Excel Data Source - Running Specific Sheet

GambitGambit Posts: 12
edited January 9 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)

Tagged:

Comments

  • jakubiakjakubiak Posts: 357 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: 149 ✭✭

    @surajjaldu
    You can parametrize File Path with variables from environment, for example:
    ${soa_env:Variablel}/calc_values.xlsx

    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 docs.parasoft.com

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

    --
    Ireneusz Szmigiel
    http://www.catb.org/esr/faqs/smart-questions.html

  • 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.