Using collection to form loops on excel

[Anonymous]

Hi I am stuck on trying to use collections to form a loop process on excel. E.g. I have 5 rows stored in the collection, I want to form a loop so that it goes through each row one at a time (by using 'save as' before the loop end). I am trying to do this using the "Write Collection" on MS Excel VBO. But the problem I'm having is that this is writing the 5 rows at once rather than doing them one at a time. Is there a trick to using the "Write Collection" function so that is works through the rows one at a time, or is there any other way I should tackle this problem? Thanks

[Ravindersaini]

Hi, You can put your collection in a loop and use ""Set cell value"" action to write the values one at a time. Inside the loop put a calculation which you will use to set the cell address[i.e A1,A2...] and pass the same cell address value as input to the action ""Set cell value"". Regards, Ravinder