UiPath: How to Read Excel, Do an Online Search, and Write the Result Back to Excel
Intro This UiPath exercise takes you through the most common web automation task you face as an RPA developer: Read an Excel sheet, do a search and write the results back to the Excel. Learning Objectives Combine Excel with web automation Description Download the course files Read the Excel sheet Iterate through each row Do […]
Table of Contents
Intro
This UiPath exercise takes you through the most common web automation task you face as an RPA developer: Read an Excel sheet, do a search and write the results back to the Excel.
Learning Objectives
- Combine Excel with web automation
Description
- Download the course files
- Read the Excel sheet
- Iterate through each row
- Do a CVR lookup at https://datacvr.virk.dk/
- Make sure to click English in the upper right corner
- Fill in all the empty columns in the Excel sheet
- Can you handle errors:
- Try to create the following entries
- 12345678
- 8
- And combat both exceptions
- Try to create the following entries
Hints
- You might want to use a Check App State to make sure, you’re on the correct company page