Not clear what you have on original array and how would you like to dived it.
pl. provide an example...we can give a try
Also not clear why you make a big array out of excel items instead of creating small arrays you need at first instance.
something like below...........
Array=[]
for i in range(2, RowCount+1):
getValue = VarToString(Excel.Cells.Item[i,2])
Array.append(getValue)
if getValue == "keys": # have to identify if it's a key( looking at actual data)
Log.Message(Array[i]) # or a function call to do what you need to do with array........
Array.clear()
or if you would like to break array to equal part run and see below code......
C = ['a', 'b', 'c', 'd', 'e', 'f', 'g', 'h', 'i', 'j', 'k', 'l', 'm', 'n',1,2]
def list_slice(S, n):
return [S[i:i+n] for i in range(0,len(C),n)]
def showSlices():
Log.Message(str(list_slice(C,4)))