Skip to content
Contact
Menu

Free tutorial

UiPath: How to Read Excel, Do an Online Search, and Write the Result Back to Excel

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…

Anders Jensen Automation & AI Instructor

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

More tutorials

  • Use Cases

    Practical UiPath use cases: complete walkthroughs of real automation tasks.

    Read more →

  • Drop Down Menus in UiPath (Find Children & Select Item)

    Free tutorial from andersjensenorg: Drop Down Menus in UiPath (Find Children & Select Item). Video walkthrough, exercise files, hints, and solutions.

    Read more →

  • For Each Loops in UiPath

    This full video tutorial shows, how to use For Each Loops in UiPath. Follow me on Twitter and learn RPA

    Read more →