SoaTest CLI - Excel Data Source - Running Specific Sheet

GambitGambit Posts: 8
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: 270 ✭✭✭

    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: 135 ✭✭

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