How to extract tables from websites from a list of links in excel sheet?

Question

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

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.

Is there a better way of doing this?

Answer 1

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