I am a newbie in UiPath. Could you please help me out to build this robot for the task below?
I have Excel file with list of URLs (product details page links).
So, I need robot to open every each link from Excel file in separate browser window. – this part I know how to do it
Scrap particular data from each product web page
Name of the product
General Specification details
Automatically save this data for each URL / product by column in the SAME Excel file (EX: Result.xlsx)
(Ideally) I would like to save data in by rows (horizontally) not by columns (vertically)
I heard some ideas like:
1 – Build DataTable > Scrap data > Load it to DataTable > Use WriteRange activity to save it into Excel file + write settings so it adds new column every each time it scraps data.
2 –(NOT to create DataTable), but Scrap data > Use WriteRange activity to save it into Excel file + write settings so it adds new column every each time it scraps data.
What is the best way that will work? Please help.
Thanks in advance.