I have an Excel file with a list of company names as input. I need to automate the process of searching for each company, extracting its address, and updating the Excel file with the corresponding address mapped to each company name.
Please elaborate your requirement more clearly.
If you want to directly update excel file then you can use excel activities.
If you want to process as transactions then you can use Re-Framework.
If you want to update programmatically then you can use Linq or datatable related activities.
Hi @rahul.g
Correct me if my understanding is wrong,
You have an excel file with listed of company name.
with each company name you are going search some web portal and get the address and you need to update in excel next to company column.
if this is correct, follow below steps
Use reframework for better exceptions handling and structured flow.
Follow below tutorial for better understanidng and how to implement your logic in reframework with tabular data
Happy Automation!
Hi @rahul.g
If you want to perform excel automation you can just read the excel file and use for each row in data table activity to iterate and search the values then you can use write cell activity to update the value in excel
This can be automated in UiPath.
A common approach is:
Read the company names from Excel, loop through each row, search the company on the target website or search engine, extract the address, and then write the address back to the same Excel row.
For implementation:
Use Read Range to get the company list, then inside For Each Row perform the search. Use Type Into / Navigate To for searching, Data Scraping or Extract Table Data to capture the address, and then Write Cell / Write Range to update Excel
@Rohit_More @kalaiselvi_selvi @Dhruba_Jyoti_Kalita @yedukondaluaregala Thank you for your support. However, the main requirement is to fetch the company address. I need help with extracting only the address. Are there any AI activities or methods available that can help retrieve just the address? I will handle the Excel part myself.
You can use get text activity to extract the address from your application.
@rahul.g
If it’s just web automation you can fetch the values using get text. If you are extracting in table format in webpage you can scrape it using data scrapping activities as well
@rahul.g Yes, you can also try ScreenPlay if you want a more AI-assisted way to extract information from the page. ScreenPlay can analyze the screen content and help capture specific data like an address when the layout is not very structured. Please let me know if you need help on Screenplay setup