Calling a function using the variable name read from XL

[User_Pilot]

I'm a novice in QTP. Actually, our team is developing a framework for our web application. We just need to confirm something regarding the function call in QTP.

Scenario:

We have myltiple tasks list (which is stored in a xl) which needs to be completed for completing a workflow in our application. We are plaaning to store these tasks as rows in an xl. We need to read this taks to a variable and have to call the function corresponding to that task from the library. The function name will be same as the task name.
i.e let task 1=aabbcc , here we have to call a function names AABBCC() in the script. We are reading the task from XL to a variable Var=AABBCC then we have to call the function AABBCC() without using select case(because we have 200+tasks in our system!! )

Can anyone help me out in this?

Thanks in Advance!!

[PrabhatN]

Hi,

At first, import all the data from the excel sheet to the QTP data table. Create a Driver Script action where you will be calling all the actions related to specific task. In the Driver Script action write the following code:

Code:

getTaskCount = DataTable.LocalSheet.GetRowCount
For counter=1 To getTaskCount
    DataTable.SetCurrentRow(counter)
    RunAction DataTable("Tasks",dtLocalSheet), oneIteration
Next

It really doesn't matter how many tasks you have in the data table, it will go on calling the actions as many time as you want

Hope this will help you. Plese write if want further clarifications

[User_Pilot]

Thanks Prabhat. We are just in the planning phase. Once I try this out I'll get back to you.