Forum Discussion

DanH's avatar
DanH
Contributor
6 years ago

Can you change the data source used in a Data Driven Loop using a script?

I'm wanting to change the datasource (Excel spreadsheet) used in a Data-Driven loop.  The scenario is, I have some tests which work fine, but I would like to feed different data into them from an Exc...
  • tristaanogre's avatar
    tristaanogre
    6 years ago

    Yes.  Question, though, is whether or you're doing Keyword testing or Script testing.  Script testing is easy... just make the excel file path in the ExcelDriver method  a variable and change the variable assignment.

     

    For Keyword testing, not quite so easy.   What I would do is put the loop in script code and call the keyword test within the loop.

tristaanogre's avatar
tristaanogre
Esteemed Contributor
6 years ago

Yes.  Question, though, is whether or you're doing Keyword testing or Script testing.  Script testing is easy... just make the excel file path in the ExcelDriver method  a variable and change the variable assignment.

 

For Keyword testing, not quite so easy.   What I would do is put the loop in script code and call the keyword test within the loop.

  • DanH's avatar
    DanH
    Contributor
    6 years ago

    Great, thanks for the reply.  I'm in  and out of meetingts at the moment, but will have a play as soon as I can. 

     

    The current tests are KeyWord tests, and I'll look into calling the tests from a loop in a scrippted test.... I'm also wondering whether it might be worth simply converting the Keyword tests to script:  which might make it easier to change other aspects of the tests using scripts.