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 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

Hints

  • You might want to use a Check App State to make sure, you’re on the correct company page

Video Guide