Datadriven Using Excel for Scripts
I want to use excel sheet for different test cases.
Value corresponding to ScriptName Column will be the function name as well in TestCase Script file.
Please help how to read and write values ...
Forum Discussion
Read the excel data and store in RecordSet as Shankar mentioned,
Use those values to build the function name and its arguments as a String Variable. Finally pass the variable to eval method to run the script which is present in the script file
Eg in Vbscript
Builder = objRS.Fields("ScriptName").Value & "(""OR_" & objRS.Fields("Username").Value & """)"
Eval(Builder) - This will identify the function in TestCase Script file and will run it.
