topic How to get data of different worksheet into different colletion in Product Forum https://community.blueprism.com/t5/Product-Forum/How-to-get-data-of-different-worksheet-into-different-colletion/m-p/68742#M21347 <DIV class="media" style="overflow: hidden; zoom: 1;"><span class="lia-inline-image-display-wrapper" image-alt="17652.png"><img src="https://community.blueprism.com/t5/image/serverpage/image-id/17804iF168430A8073D7A7/image-size/large?v=v2&amp;px=999" role="button" title="17652.png" alt="17652.png" /></span><BR />Hi all ,<BR /><BR />I am unable to loop through in such a way that i can store multiple sheet data into multiple collections .</DIV><BR /><BR />------------------------------<BR />RPA DEV ASSTNT MGR<BR />AIG<BR />------------------------------<BR /> Fri, 30 Aug 2019 13:40:00 GMT SankalpKabra 2019-08-30T13:40:00Z How to get data of different worksheet into different colletion https://community.blueprism.com/t5/Product-Forum/How-to-get-data-of-different-worksheet-into-different-colletion/m-p/68742#M21347 <DIV class="media" style="overflow: hidden; zoom: 1;"><span class="lia-inline-image-display-wrapper" image-alt="17652.png"><img src="https://community.blueprism.com/t5/image/serverpage/image-id/17804iF168430A8073D7A7/image-size/large?v=v2&amp;px=999" role="button" title="17652.png" alt="17652.png" /></span><BR />Hi all ,<BR /><BR />I am unable to loop through in such a way that i can store multiple sheet data into multiple collections .</DIV><BR /><BR />------------------------------<BR />RPA DEV ASSTNT MGR<BR />AIG<BR />------------------------------<BR /> Fri, 30 Aug 2019 13:40:00 GMT https://community.blueprism.com/t5/Product-Forum/How-to-get-data-of-different-worksheet-into-different-colletion/m-p/68742#M21347 SankalpKabra 2019-08-30T13:40:00Z RE: How to get data of different worksheet into different colletion https://community.blueprism.com/t5/Product-Forum/How-to-get-data-of-different-worksheet-into-different-colletion/m-p/68743#M21348 You can add a field of type collection inside one collection and then set that collection in loop.<BR /><BR />------------------------------<BR />Gopal Bhaire<BR />Analyst<BR />Accenture<BR />------------------------------<BR /> Sat, 31 Aug 2019 10:30:00 GMT https://community.blueprism.com/t5/Product-Forum/How-to-get-data-of-different-worksheet-into-different-colletion/m-p/68743#M21348 GopalBhaire 2019-08-31T10:30:00Z RE: How to get data of different worksheet into different colletion https://community.blueprism.com/t5/Product-Forum/How-to-get-data-of-different-worksheet-into-different-colletion/m-p/68744#M21349 Hi Gopal! I'm having the same doubt... Could you please detail a bit more of your solution please? Thanks a lot!<BR /><BR />------------------------------<BR />Rita Reis Cabrita<BR />------------------------------<BR /> Mon, 15 Feb 2021 16:31:00 GMT https://community.blueprism.com/t5/Product-Forum/How-to-get-data-of-different-worksheet-into-different-colletion/m-p/68744#M21349 RitaReis_Cabrit 2021-02-15T16:31:00Z RE: How to get data of different worksheet into different colletion https://community.blueprism.com/t5/Product-Forum/How-to-get-data-of-different-worksheet-into-different-colletion/m-p/68745#M21350 Hi Sankalp,<BR /><BR />I can't think of a simple way for this to be done, but there are a few options available. In order to better advise, please can you let me know if the data from one worksheet to the next is in the same format (same column number and names) and could be merged.<BR /><BR />Also, is the workbook consistent? Does it always have the same worksheets, with the same names. Or can it have a different number of worksheets each time, with different worksheet names?<BR /><BR />Thanks<BR /><BR />------------------------------<BR />Ben Lyons<BR />Product Consultant<BR />Blue Prism<BR />UK<BR />------------------------------<BR /> Tue, 16 Feb 2021 09:21:00 GMT https://community.blueprism.com/t5/Product-Forum/How-to-get-data-of-different-worksheet-into-different-colletion/m-p/68745#M21350 Ben.Lyons1 2021-02-16T09:21:00Z RE: How to get data of different worksheet into different colletion https://community.blueprism.com/t5/Product-Forum/How-to-get-data-of-different-worksheet-into-different-colletion/m-p/68746#M21351 Create Workbook collection with a field of collection type, name it Worksheet.<BR />Open Workbook, read all worksheet names, loop over it and in that loop add row to Workbook collection and read from [Workbook Names.Name] sheet to Workbook.Worksheet collection - you'll end up with all your sheets in Workbook collection, each sheet in it's own row as nested collection.<BR />Finally close the file&amp;excel instance.<BR /><BR />This can be improved by adding Sheet names etc.&nbsp;<BR /><BR />p.s. Attached screenshot and my action that you should be able to select all and copy to clipboard and just right click paste into blueprism process action bar (dont try importing it or anything). Hopefully excel vbo I picked is the right one, we got several.<BR /><BR />------------------------------<BR />Andrey Kudinov<BR />Project Manager<BR />MobileTelesystems PJSC<BR />Europe/Moscow<BR />------------------------------<BR /> Tue, 16 Feb 2021 23:00:00 GMT https://community.blueprism.com/t5/Product-Forum/How-to-get-data-of-different-worksheet-into-different-colletion/m-p/68746#M21351 AndreyKudinov 2021-02-16T23:00:00Z