HOW TO SCRAPPING MULTI RESULTS INTO AN EXCEL TABLE

Help
,
1

Hello,
I need a good practice for this use case:

  • I have a column with a unique numbers let’s name it (Main Number)
  • there is a website which I can put that main number and get branch numbers.
  • Usually one main number have many branches numbers
  • I need the result in excel in two columns, column 1(Main Numbers), column2 (Branch numbers)

how to do that?
even in studio if it is not possible in Studiox

2

Hello @111568
First, add unique numbers to an excel file with its title and add the titles to where you will print the results.
Then open browser read excel files.
Print the data in the excel file with the input type instead of in the site.
Get the results with get full text and write them to the excel file.
I recommend using for each row when writing from your Excel file to the site.
While writing the data in excel to the site (row.Item (“value”)). You can do ToString.