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