For Each Row in Data Table copy the content in a variable

I’m looking to update my variable called “website” reading each row in Excel file which content a URL.
How to I get URL from Excel and paste it (Assign) to the variable?



Say for example your URL value is in a column named URL in that datatable then the assign activity will be like this

Website = CurrentRow(“URL”).ToString

Where website is a string variable

Generally the syntax is
Website = CurrentRow(“your columnname”).ToString


Website = CurrentRow(column index).ToString

Column index usually starts from 0 for first column

Hope this would help you

Cheers @IPIX

Yeahhh… it works! Thanks!

1 Like

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