Forum Discussion

Chris2024's avatar
Chris2024
Occasional Contributor
3 months ago

Multiple execution of a test plan with different values from an Excel table

Hello SmartBear Community,

Is it possible to execute all test cases in an execution plan multiple times based on variables in an Excel table?

Example

  • Iteration 1:
    • Test case 1: Login as "user 1"
      Test case 2: Logout as "user 1"
  • Iteration 2:
    • Test case 1: Login as "user 2"
      Test case 2: Logout as "user 2"
  • Iteration n:
    • Test case 1: Login as "user n"
      Test case 2: Logout as "user n"

The user data is saved in an Excel table and there should be as many iterations until all rows have been run through.

Best regards,
Christopher

12 Replies

  • Mr_Bro's avatar
    Mr_Bro
    Frequent Contributor

    HI Chris2024,

    the other way to achieve it is as below:

    • Create a script (Drive) which drives your execution and add only this in your execution and internally you can handle to read your excel using ADODB for excel.
    • loop through the record set object which holds the value of your user (user 1, user 2, _, , user n)
    • call the methods or the functions written in your script
    • Chris2024's avatar
      Chris2024
      Occasional Contributor

      So far I have only been able to find documented solutions for creating data-driven test cases. Unfortunately, there are no solutions for creating data-driven execution plans. How would you implement the example shown above in Testcomplete?