ContributionsMost RecentMost LikesSolutionsRe: Can anyone please help me with using Tuples in TestComplete with Python 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 How to get row count and column count using DDT driver? Hi, Can anyone please help me with how to get row count and column count of an excel using DDT driver. I dont want to store the excel into variables of TestComplete. But i need to get the row count and column count using DDT. Can anyone please help me with this? Re: How to perform action using Excel data in TestComplete with Python Hi baxatob Can you Please help me with this one? Re: How to click after finding an object Thank you baxatob.. Its working absolutely fine now.. Re: How to click after finding an object Hi shankar_r I am getting error as "Type Mismatch" How to click after finding an object Hi All, I need to perform some action after finding an object using Find, FindAll or FindChildren methods. Can anyone please explain how to go about this? Like click on the object after finding it using Find or FindAll methods. I have gone through the smartbear website for find and findAll. But it didnt help. I tried with this code: def clickControlID(): TestedApps.Sound_PE.Run() Delay(5000) Login=Sys.Process("SoundPE").WinFormsObject("DialogLogin") clkLogin=Login.FindAllChildren("WinFormsControlName","buttonOK",20) clkLogin.Click() I am getting the error for this code as: AttributeError: 'SafeArrayWrapper' object has no attribute 'Click' SolvedRe: Can anyone please help me with using Tuples in TestComplete with Python Hi baxatob I have attached the screenshot for the above. Re: Can anyone please help me with using Tuples in TestComplete with Python 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. Re: Can anyone please help me with using Tuples in TestComplete with Python baxatob I know to print the values from the list. my_list = [1, 2, 3, 4, 5] my_list[0] == 1 my_list[-1] == 5 But i am not able to print using the script which you have sent test_case_container = DDT.ExcelDriver("C:\\TestCases.xls", "Sheet1") 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["ExecutionFlag(Y/N)"] == "Y": tests_to_run.append(test_case_container.Value["TCID"]) test_case_container.Next() return tests_to_run When i call this method inside a script i will get the result as ['TC1138', 'TC996', 'TC1135', 'TC1138', 'TC1140']. Now i need to fetch the first value from the list. I have tried with this code: test_case_container = DDT.ExcelDriver("C:\\Users\\TESTPC\\Desktop\\TestDoc.xlsx", "Sheet1", True) def get_test_suite(): tests_to_run = [] # creating an empty list while not test_case_container.EOF(): if(test_case_container.Value["Execute-Flag(Y/N)"] == "Y"): test=tests_to_run.append(test_case_container.Value["TCID"]) test_case_container.Next() return tests_to_run def test(): Log.Message(str(get_test_suite())) A=[get_test_suite()] Log.Message(str(A[1])) But i am not able to fetch the values. Can you please help with this problem? Re: Can anyone please help me with using Tuples in TestComplete with Python Hi baxatob. I was asking like how to print only the first value? Like from ['TC1138', 'TC996', 'TC1135', 'TC1138', 'TC1140'] i need to print only 'TC1138'. Can you help with this problem?