https://community.blueprism.com/t5/Product-Forum/Using-collection-to-form-loops-on-excel/m-p/91226#M41287 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 Wed, 08 Feb 2017 21:34:00 GMT Anonymous 2017-02-08T21:34:00Z https://community.blueprism.com/t5/Product-Forum/Using-collection-to-form-loops-on-excel/m-p/91226#M41287 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 Wed, 08 Feb 2017 21:34:00 GMT https://community.blueprism.com/t5/Product-Forum/Using-collection-to-form-loops-on-excel/m-p/91226#M41287 Anonymous 2017-02-08T21:34:00Z https://community.blueprism.com/t5/Product-Forum/Using-collection-to-form-loops-on-excel/m-p/91227#M41288 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 Thu, 09 Feb 2017 09:54:00 GMT https://community.blueprism.com/t5/Product-Forum/Using-collection-to-form-loops-on-excel/m-p/91227#M41288 Ravindersaini 2017-02-09T09:54:00Z