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

     

     

     

     

shankar_r's avatar
shankar_r
Community Hero
8 years ago

Rajesh2all of the methods and properties used below are same as Excel via COM there is no difference

 

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

 

Refer here http://support.smartbear.com/testcomplete/docs/testing-with/advanced/working-with-external-data-sources/excel/working-via-com.html

pavanmac's avatar
pavanmac
Contributor
8 years ago

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: