使用UiPath循环来自Excel文件的URL [英] Looping on URLs from Excel file using UiPath

问题描述

我尝试了几种方法，但是它们看上去不干净；

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

1. 我有一个Excel格式的URL文件(一列中有400多个url)
2. 我希望UiPath从该文件读取并逐个浏览这些URL

我尝试从一个从Excel读取的变量中读取导航到"，但是它变得混乱并且无法正常工作.

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.

据我了解，您有一个Excel文件，其中包含包含URL的列，并且您想访问每个URL-在这种情况下:

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:

1. 参加一个excel应用程序范围活动给出您的路径 excel文件...创建一个DataTable对象.
2. 使用For Each Row活动，提供您的DataTable对象.
3. 在循环中，使用Assign活动，并设置url=row.Item("urlColumnname").ToString()
4. 使用Navigate To活动来访问每个URL.

1. Take one excel application scope activity Give the path of your excel file...Create one DataTable object.
2. Use a For Each Row activity, providing your DataTable object.
3. Within the loop, use an Assign activity, and set url=row.Item("urlColumnname").ToString()
4. Use an Navigate To activiy to visit each URL.

这篇关于使用UiPath循环来自Excel文件的URL的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！