I have an excel that contains 100 website link. I created a workflow that can read each cell and open browsers but I can’t create a loop (or while) for data scrapping. When I try it, data scrapping tool scraps only first web page’s data. All web pages have the same table. How can I loop data scrapping?
1.Use Excel application scope activity pass the path of excel file.
2.Next use read range activity pass the sheet name and create output data table variable.
3.Use for each row activity pass the data table variable and then use open browser pass the row(“ColumnName”).After that you can use data scrapping.