How to Compare Excel Sheets in UiPath (Full Tutorial)

Comparing Excel Sheets, Tables, and DataTables in UiPath is a task you’ll often face as an RPA Developer.

This guide shows you how.

πŸ“‚ Download the Course Materials: Download Excel Book
πŸ‘¨β€πŸ‘©β€πŸ‘§β€πŸ‘¦ Get free UiPath help and network with 1600+ RPA Developers: Discord

Course Exercises

Compare Excel using UiPath Activities

Using the UiPath activities has several advantages: Easy to follow the logic and add/combine it with other activities. The disadvantage is that it could be done with fewer lines of code/activities (see the below LINQ sections).

Find matching rows (Intersect)

  • Find matching values of the two Excel sheets and update a column
  • Find and copy the matching rows of the two Excel Sheets/Tables to a new Excel Sheet

Find unique rows (Except)

  • Update row in Sheet1 if the row is not present in Sheet2
  • Find and copy the rows that are present in Sheet1 and not in Sheet2 to a new Excel Sheet

Combine two Excel Sheets (Union)

  • Combine Sheet1 and Sheet2, remove duplicates and write to a new sheet.

Compare Excel using LINQ

  • Find matches in Sheet1 and Sheet2 using LINQ
  • Find unique rows in Sheet1 relative to Sheet2 using LINQ
  • Find all unique rows in Sheet1 and Sheet2 using LINQ

Compare Excel using Advanced LINQ

  • Find matches in Sheet1 and Sheet2 using LINQ
  • What happens when there is no match? Error Handling
  • Find unique rows in Sheet1 relatively to Sheet2 based on Columns

Full Video Tutorial

Anders Jensen

RPA DEVELOPER, YOUTUBER & TWO-TIME UIPATH MOST VALUED PROFESSIONAL (2021 & 2022) Anders has been running andersjensenorg fulltime since December 2021. The company specializes in teaching RPA via YouTube and tailormade learning paths. Anders is an experienced RPA-developer and -teacher with experience in both the public and private sectors. Anders’ YouTube channel has trained more than 100.000 Citizen Developers in just one video. Alongside his YouTube channel, Anders has built a unique global RPA-community with developers on all levels. When using Anders as your partner for RPA-trainings, you get direct access to this unique opportunity for problem-solving, opportunities, and networking.

Leave a Reply