https://community.blueprism.com/t5/Product-Forum/Setting-Collection-Fields-from-Excel/m-p/63676#M16578 Is there way to set the Collection Fields using data from a certain row from an excel file?<BR /><BR />FYI, I'm first getting the worksheet as a collection.&nbsp; Then I want to set the Collection Fields using the data on row 10.&nbsp; How do I accomplish this?&nbsp; Thanks.<BR /><BR />------------------------------<BR />David Chu<BR />Tax Technology Manager<BR />WestRock<BR />America/New_York<BR />------------------------------<BR /> Fri, 03 Jan 2020 22:12:00 GMT DavidChu 2020-01-03T22:12:00Z https://community.blueprism.com/t5/Product-Forum/Setting-Collection-Fields-from-Excel/m-p/63676#M16578 Is there way to set the Collection Fields using data from a certain row from an excel file?<BR /><BR />FYI, I'm first getting the worksheet as a collection.&nbsp; Then I want to set the Collection Fields using the data on row 10.&nbsp; How do I accomplish this?&nbsp; Thanks.<BR /><BR />------------------------------<BR />David Chu<BR />Tax Technology Manager<BR />WestRock<BR />America/New_York<BR />------------------------------<BR /> Fri, 03 Jan 2020 22:12:00 GMT https://community.blueprism.com/t5/Product-Forum/Setting-Collection-Fields-from-Excel/m-p/63676#M16578 DavidChu 2020-01-03T22:12:00Z https://community.blueprism.com/t5/Product-Forum/Setting-Collection-Fields-from-Excel/m-p/63677#M16579 NM, I figured it out.&nbsp; I was looking at the wrong VBO.&nbsp; I should've been looking into the Excel VBO instead of the Collection VBO.&nbsp; Excel VBO as Get Worksheet as Collection Offset action.<BR /><BR />------------------------------<BR />David Chu<BR />Tax Technology Manager<BR />WestRock<BR />America/New_York<BR />------------------------------<BR /> Mon, 06 Jan 2020 13:47:00 GMT https://community.blueprism.com/t5/Product-Forum/Setting-Collection-Fields-from-Excel/m-p/63677#M16579 DavidChu 2020-01-06T13:47:00Z