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]))

     

     

     

     

baxatob's avatar
baxatob
Community Hero
8 years ago

Your code:

 

 

A = [get_test_suite()]

 

 

will provide the following result:

 

 

[ ["Value1", "Value2", "Value3"] ]

 

If you call A[0] it will return ["Value1", "Value2", "Value3"]

If you call A[1] it will raise an IndexError

However if you call A[0][0] it will return "Value1"

 

Try simply:

 

 

A = get_test_suite()

 

Rajesh2's avatar
Rajesh2
Contributor
8 years ago

baxatob Thank you for the answer. But I am getting the result as []

 

I tried with following ways

 

1. def test():
A=[get_test_suite(test_case_container)]
Log.Message(str(A[0]))

 

2. def test():
A=[get_test_suite(test_case_container)]
Log.Message(A[0])

 

3.def test():
A=[get_test_suite(test_case_container)]
Log.Message(str(A[0][0]))

 

4.def test():
A=[get_test_suite(test_case_container)]
Log.Message(A[0][0])

 

But i am not getting the values in Result. Can you please help me with this Baxatob.

  • Rajesh2's avatar
    Rajesh2
    Contributor
    8 years ago

    Hi baxatob I have attached the screenshot for the above.

    • baxatob's avatar
      baxatob
      Community Hero
      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]))

       

       

       

       

      • Rajesh2's avatar
        Rajesh2
        Contributor
        8 years ago

        Hi baxatob. If you dont mind, Can you please tell me how to do the same using Excel via COM.

         

        I have tried with this:

        def Control_Actions1():
        Excel = Sys.OleObject["Excel.Application"]
        Excel.Workbooks.Open("C:\\Users\\TESTPC\\Desktop\\Cochlear_CSEP2.xlsx").Sheets.Item["TC_Nav_ SP_Implant"]


        RowCount = Excel.ActiveSheet.UsedRange.Rows.Count
        ColumnCount = Excel.ActiveSheet.UsedRange.Columns.Count
        Log.Message(RowCount)
        Log.Message(ColumnCount)

        tests_run=[]
        for i in range(0,RowCount):
        for j in range(0,ColumnCount):
        if(Excel.Value["TCID"] == "Ctrl_ID"):
        test=tests_to_run.append(test_case_container.Value["TC1138"])
        test_case_container.Next()
        return tests_to_run