Explore Courses Blog Tutorials Interview Questions
0 votes
in RPA by (5.3k points)

I am having trouble iterating through a list of links within an excel sheet.

enter image description here

How do I link the excel sheet to the for loop in Uipath?

I tried using Get Workbook Sheet to extract the table from the excel file.


Here are the properties for Get Workbook Sheet.

enter image description here

Is there a better way of doing this?

1 Answer

0 votes
by (9.5k points)

Try to use macros or VBA for this, here you will give reference to MSXML library and to fetch the whole page, use XML HTTP request.

then that would be inside a loop/iteration of all the URL's, as next step parse the XHR result as HTML then query for all table elements.use paste or VBA paste into the new sheet

Related questions

+1 vote
1 answer
0 votes
1 answer
+2 votes
1 answer
0 votes
1 answer
Welcome to Intellipaat Community. Get your technical queries answered by top developers!

30.5k questions

32.5k answers


108k users

Browse Categories