Iterate through Column of datatable/xlsx File

Hello :slight_smile:
I have a List of contract Numbers (Dt in UiPath and Xlsx File) which Updates Every Hour. There is a column Header and then an amount of n contract Numbers (one per Row). What would be the smartest way to iterate through this List and perform certain actions on them? Thanks Guys

If it’s a datatable then obviouyGOR EACH ROW activity will be the best if we want to do some modification along the column for each iteration of rows using a Assign activity like this
row(“yourcolumnname”) = “any value we want”


If it’s a collection variable or a array variable then FOR EACH activity can be used where pass the above variable as input and change the type argument as the datatype of that array or collections variable

Cheers @SSchmitz


If you want to make changes to the data table, then use read range and perform manipulations using a for-each row.

If you’re not making changes to the data table say, if you only want the values from the column, you can use read column and use for-loop which returns an IEnumerable list so, you can perform your manipulations using the values.

Let me know in case of any queries, @SSchmitz :slight_smile:

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.