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

[IPIX]

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?

[Palaniyappan (Forum Leader)]

Hi

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

Or

Website = CurrentRow(column index).ToString

Column index usually starts from 0 for first column

Hope this would help you

Cheers @IPIX

[IPIX]

Yeahhh… it works! Thanks!