Can someone please help ,I have to get into URLs from excel file and put the reference of the those things , and get price of the same things in those 3 sites and after that i have to put the 3 values in the a new sheet to compare them , i need answers wi

how open different URLs from excel one by one and then from that URLs i want to get specific data uipath and save it in next sheet

@marooboukadida

Welcome to our UiPath community.

  1. Use Read Range activity inside Excel Application Scope activity to read the data from excel file. It will give output as DataTable. Let’s say dtInput.

  2. And then use ForEach Row activity as below.

     For Each row in dtInput
        - Use Open Browser and pass url as row("ColumnName").ToString
        - Read specific data from web page. 
        - Write into Excel file
    
1 Like

thanks , but can you please give those steps by details until i save the data from web page in the next sheet , im still new in UIpath

Can someone please help ,I have to get into URLs from excel file and put the reference of the those things , and get price of the same things in those 3 sites and after that i have to put the 3 values in the a new sheet to compare them , i need answers with details , thanks