cancel
Showing results for 
Search instead for 
Did you mean: 

Setting Collection Fields from Excel

DavidChu
Level 3
Is there way to set the Collection Fields using data from a certain row from an excel file?

FYI, I'm first getting the worksheet as a collection.  Then I want to set the Collection Fields using the data on row 10.  How do I accomplish this?  Thanks.

------------------------------
David Chu
Tax Technology Manager
WestRock
America/New_York
------------------------------
1 REPLY 1

DavidChu
Level 3
NM, I figured it out.  I was looking at the wrong VBO.  I should've been looking into the Excel VBO instead of the Collection VBO.  Excel VBO as Get Worksheet as Collection Offset action.

------------------------------
David Chu
Tax Technology Manager
WestRock
America/New_York
------------------------------