Write/Output to excel sheet.
I want to loop through the Global sheet and run a test: "Action1". "Action1" will extract/output/write to the excel sheet or some sheet that will be read by "Action2" another test that should run after "Action1" is complete
I am facing problem writing to the excel sheet or data sheet, when a write to a datatable and Action1 is complete, the datasheet is not saved unless I export it at the end of "Action1" and then manual important that and start my second test on that DataTable.
Re: Write/Output to excel sheet.
Your output values from ACTION 1 get saved to the RumTime datatable. In the Results windows of action1..Click on Datatable on the top and you should be able to see all the output values..QTP saves run time values into runtime datatable and it does not save it to the static table.
One way is to call action2 at the end of action1 so that action 2 is executed immediately after action1 and then action 2 can make use of the runtime datatable from action1
or export it before the end of action 1