ContributionsMost RecentMost LikesSolutionsRe: How to split an array ? Hi , Thank you for the reply. NisHera Actually we have test cases with navigation steps followed. So, based on the testcase we need to fetch the navigation values and store it inside an array. Then this array should be split into 4 slices and for each slice i need to send the navigation step to it and should pass to all the values till the excel cell reads null.. EX: For ctrl_ID it should read ctrl_id and send buttonok to the application.. and it should do it till the excel cell value is null. I have the excel sheet attached to it please take a look into it! This should be done in testcomplete using Python !! How to split an array ? How to split an array ? Array=[ctrl_id, data, action, keys] This should be done using testcomplete with python. Array=[] for i in range(2, RowCount+1): #for j in range(1, ColumnCount + 1): getValue = VarToString(Excel.Cells.Item[i,2]) #+ '\r\n' Array.append(getValue) for i in range(len(Array)): Log.Message(Array[i]) can any one please help me with this. Re: How to fetch the value from excel . How to split an array ? Array=[ctrl_id, data, action, keys] This should be done using testcomplete with python. Re: Can anyone please help me with using Tuples in TestComplete with Python 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. Re: How to fetch the value from excel . Yes , i agree baxatob If you could find 1 please let me know. I would like to know about it.. Thanks in advance!! Re: How to fetch the value from excel . Thank you shankar_r Will do as per your suggestion!! Re: How to fetch the value from excel . Hi, You mean that there is no solution for the fashion it is written in excel??(Testcomplete with python) Re: TestComplete 301 new date and time! Yes surely will register for it!! Re: How to fetch the value from excel . Hi baxatob As the ctrl_ID is repeating for test case in excel row. I am not able to fetch the value for all the ctrl_id and condition is (ctrl_id , ctrl_type , atcion , data) these 4 set of values can be increased or decreased and code should work in spite of this. Attachment show these 4 set of values. Re: How to fetch the value from excel . My question here is : Now as tc1138 is selected. It should navigate through different steps. I have attached the screen shot. From Testcase 1138 row of excel it should fetch all the cell values with column name ctrl_ID , CTrl_type Action Data. How to go about this?