Forum Discussion

Rajesh2's avatar
Rajesh2
Contributor
8 years ago
Solved

Can anyone please help me with using Tuples in TestComplete with Python

Hi,   I need to fetch the testcases based on the ExecutionFlag(Y/N) from Excel   I need to store the testcases which have ExecutionFlag="Y" and store it in Array.   Now i need to create a loop ...
  • baxatob's avatar
    baxatob
    8 years ago

    This should work:

     

    A = get_test_suite(test_case_container)
Log.Message(str(A[0]))

    as well as this:

     

    A = [get_test_suite(test_case_container)]
Log.Message(str(A[0][0]))

     

     

     

     

pavanmac's avatar
pavanmac
Contributor

Can anyone help me with this:

 

def get_test_suite(test_case_container):

tests_to_run = [] # creating an empty list

while not test_case_container.EOF():
if test_case_container.Value["TCID"] == "1138":
tests_to_run.append(test_case_container.Value["Ctrl_ID"])

test_case_container.Next()

return tests_to_run

def testd():
test_case_container = DDT.ExcelDriver("C:\\Users\\admin\\Desktop\\xyz.xlsx", "TC_Nav", True)
A = [get_test_suite(test_case_container)]
Log.Message(str(A))

 

I want to fetch the value of 1st ctrl_ID.. Then next ctrl_id

 

I have the table attached.

baxatob's avatar
baxatob
Community Hero
8 years ago
...

while not test_case_container.EOF():
    if test_case_container.Value["TCID"] == "Ctrl_ID":
        Log.Message(test_case_container.Value["TC1138"]

...

But this is still not optimal way, imho.

I suggest to use: