uipath循环datatable,使用UiPath在Excel文件中循环访问URL

I have tried several ways but somehow they dont look clean;

I have a URL file in Excel format (400+ urls in a column)

I want UiPath to read from that file and browse these URLs one by one

I tried with making "Navigate to" read from a variable that reads from Excel but it just gets messy and does not work.

anyone can suggest some easy way to do it?

解决方案

Please elaborate what you want to do.

As per my understanding, you have a Excel file with a column containing the URLs and you want to visit each one - in this case:

Take one excel application scope activity Give the path of your

excel file...Create one DataTable object.

Use a For Each Row activity, providing your DataTable object.

Within the loop, use an Assign activity, and set url=row.Item("urlColumnname").ToString()

Use an Navigate To activiy to visit each URL.