Forum Discussion

rhsou123's avatar
rhsou123
Contributor
9 years ago
Solved

How to read keywords from Excel sheet and to execute them?

Please can anyone has a script that loops all the rows of an Excel sheet and Executes all the keywords picked into this Excel sheet ?  These keywords are defined into another Unit in the same project. I'm using VBscript.

 

I has a script written in VBscript and I was using it with UFT, I don't know the syntax differences between both UFT and Testcomplete if any one is happy to help me I can share with him the script to make it work.

 

  • tristaanogre's avatar
    tristaanogre
    9 years ago

    Check out the following topic:

    Using the DDTDriver Object to Retrieve Data From Excel Files

     

    While it does not do the specifics of translating UFT stuff to TestComplete, it shows how to build a DDT loop using an Excel sheet and processing information accordingly.  This is your starting point, really. In the example given, you would replace the ProcessData sub with whatever code you would need to write to execute your keyword. My guess is that it would be something like a large extended Select Case block where each keyword read in from the Excel would be parsed through as a case and, for each case, a different function is called.

  • tristaanogre's avatar
    tristaanogre
    Esteemed Contributor
    9 years ago

    Check out the following topic:

    Using the DDTDriver Object to Retrieve Data From Excel Files

     

    While it does not do the specifics of translating UFT stuff to TestComplete, it shows how to build a DDT loop using an Excel sheet and processing information accordingly.  This is your starting point, really. In the example given, you would replace the ProcessData sub with whatever code you would need to write to execute your keyword. My guess is that it would be something like a large extended Select Case block where each keyword read in from the Excel would be parsed through as a case and, for each case, a different function is called.