Forum Discussion

PMarriott's avatar
PMarriott
New Contributor
6 years ago
Solved

Changing Excel Data Source file name based on Environment change

I wish to use the same scripts but across a number of environments.  I would like each environment to use a different Excel data file to populate the data source.  However, I can not see how this can...
  • PMarriott's avatar
    6 years ago

    Found my own answer.

     

    In case anyone else is wondering, what I did was create a Custom Property "sourceFile".

    Then in the Excel data source definition, I was able to reference that Custom Property by putting "${#Project#sourceFile}" in the file name property.  I also assume (although have not yet tested) that I would be able to change the Worksheet name in the same way.

     

    Hope others find this useful.