How to Compare Excel Sheets in UiPath (Full Tutorial)
HTML-код
- Опубликовано: 27 июл 2024
- This video tutorial shows how to compare Excel Sheets in UiPath. First, use the UiPath activities (low-code) and then C# LINQ (query component and code). The same method is used when comparing Data Tables. This is a full 1-hour tutorial teaching you everything about comparing Excel Sheets in UiPath.
📂 Download the course materials: andersjensen.org/how-to-compa...
VIDEOS FOR YOU:
🔹 UiPath REFramework Full Tutorial: • UiPath REFramework - F...
🔹 UiPath Beginners Course: • UiPath Beginners Cours...
👨👩👧👦 Discord: / discord
- Join my network with +1600 RPA Developers, where we solve RPA problems, network, and help each other upgrade our careers. It's free!
FOLLOW ME:
💼 LinkedIn: / andersjensenorg
📸 Instagram: / andersjensenorg
👨 Facebook: / andersjensenorg
🐦 Twitter: / andersjensenorg
💌 Email Newsletter: andersjensen.org/email-newsle...
MY GEAR (Amazon affiliate):
🖥️ My monitor
Samsung 49-inch CRG9 Curved Monitor = geni.us/MDpejc
- If you are buying this, I can recommend the Mi Monitor Light Bar = geni.us/3Wwad
💡 Lights
IVISII 19 inch Ring Light and Stand = geni.us/fVCH3IC
Godox TL60 RGB Tube Light = geni.us/u0hxf
⌨️ Keyboard
Logitech Backlit Keyboard = geni.us/aT0ltB
📹 Camera
Sony FDRAX53-B = geni.us/gnAE
Lenovo 500 Full HD Webcam = geni.us/cZS4
🎤 Microphone
Rode Procaster = geni.us/XWvZN
Rode PSA1 Boom Arm = geni.us/LtDH275
Rode Shock Mount = geni.us/aAgP
Triton FetHead in-Line Preamp (improve your mic) = geni.us/cMAO
XLR Cable = geni.us/DfRbS
Focusrite Scarlett (you need this to connect the mic+headphones) = geni.us/BAoA6Na
- Portable mic when I travel:
Rode Wireless GO II = geni.us/iqy0g6H
0:00 Intro
Comparing Excel sheets in UiPath is very easy. First, we use the UiPath activities and then LINQ. First, we convert the Excell sheets to DataTables, making them easy to work with. Remember to download the course materials: andersjensen.org/how-to-compa....
5:17 Find matching Excel rows and update a column
We use the UiPath activities to find matching rows between two Excel sheets. First, convert the Excel sheets into Data Tables, which will make them easy to work with. Use the Add Data Column to add a new column, where we will add data if the rows match. Using a nested For Each Row in Data Table and an If, we check if we have matching (intersecting) rows.
16:13 Copy matching Excel rows to a new sheet
Still using a nested loop, we use an Add Data Row activity to add the matching Excel rows to a new sheet.
21:52 Find unique Excel rows and update a column
We find the Excel rows present in Sheet1 and not in Sheet2, that is, unique values (= Except).
27:58 Copying unique Excel rows to a new sheet
We find unique Excel rows in the nested loop and still with the If condition and copy them to a new sheet. Using an And condition to compare based on multiple column headers.
34:03 Combine two Excel sheets (Union)
Use the Merge Table to union two Excel sheets and then Remove Duplicate to remove the same rows.
37:30 Compare Excel rows using LINQ
We use LINQ in UiPath (if you can't run it, make sure you have an imported system.linq). Use the AsEnumerable method to compare two Data Tables using LINQ and then Intersect, Except, and Union methods to find the matching, unique, and joined Excel rows using UiPath.
44:27 Compare Excel rows based on columns (Advanced LINQ)
We now use LINQ to compare specific columns in the Excel sheet and then update write the results to a new sheet using UiPath.
50:17 Try Catch (Error handling our LINQ query)
Our workflow will throw an error if we try to use the .CopyToDataTable, and there are now rows in the Data Table. We use the Try Catch activity in UiPath to solve this.
#uipath #rpa #excel Наука
Do you want to pass the UiPath Advanced Certification? Then learn UiPath REFramework: ruclips.net/video/LP5y51_n6BY/видео.html 🙂
Great video. Its so easy to follow and you make sure the viewer understands whats going on.
Hey Erik, I'm so glad you found the video of use 🙂 Kind regards, Anders
super helpful video !! thank you so much
Hey apocalipmon - many thanks 💪🤩
Thank you for the lesson. It is very useful!
Hey Пісоцька. Thanks a lot 😊 Have a great day. Kind regards, Anders
Thank you so much Sir this is so helpful Thank you again god bless you
You're very welcome, Rasha Alqahtani - your support helps me a lot 😍
Thank you very much for this great video/lesson😁
You're very welcome, Andrei - did you build it yourself? 🙂 Kind regards, Anders
@@andersjensenorg Yes, every part of the lesson i made like in the video and then, i try to put new data and to personalize until i learn the method
Impressive, thanks for feedback 💪💪
This video is so helpful. Thank you so much. However, do you know how to compare multiple sheets (like 5 or 7 sheets at a times, instead of 2 sheets)?
Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 7000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
Thank you very much for this video!! I have a question; It is possible to compare two Excel files with Uipath. For example, each file has three sheets and I want to compare; sheet 1 of file 1 with sheet 1 of file 2.... sheet 2 of data 1 with sheet 2 of file 2 ....and sheet 3 of data 1 with sheet 3 of file 2.
Hey wael kaabi
Thanks for writing. I'm getting more than 40 questions/comments every day and having difficulty answering everyone (I try my best).
I've created my UiPath Groups, where we all can post and solve problems or hang out around our favorite tool, UiPath. So you're very welcome. Get the addresses here: ruclips.net/video/C6xmGfEL07I/видео.html
Have a great day.
Kind regards,
Anders
Can u please create a video on ci/cd pipeline for uipath
Hey kunal Morande
Thanks for writing. I'm getting more than 40 questions/comments every day and having difficulty answering everyone (I try my best).
I've created my UiPath Groups, where we all can post and solve problems or hang out around our favorite tool, UiPath. So you're very welcome. Get the addresses here: ruclips.net/video/C6xmGfEL07I/видео.html
Have a great day.
Kind regards,
Anders
Hi Anders🙂 - Great videos - in the session 3 and 4 - i am trying to rename to sequence "body" to "outerbody" as you show us - in my version og studie i seems that it is no longer possible ( there is'nt a rename oppotunity when i rightklick on the "body" - do you know another way to rename it
Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 9000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
Hi Sir, Can please tell me how to write ahk script for alt+page down in one key?
Hey SvR info
I worked within AutoHotkey for more than five years, but I started to find myself limited (I couldn't automate everything). As a result, I've changed the tool to UiPath. It's free as well; it's low code (drag-n-drop), the most used RPA tool in the world.
Find my beginners guide here: ruclips.net/video/sp5ZwFKfh-0/видео.html
Kind regards, Anders
AsEnumerable function is not coming up after clicking a dot , I'm not sure if i need some special packages or i should select c# when i create the project
Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 5800+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
Hi Jensen,
I need some help with an UIpath Excel compare query.
Suppose we are comparing 2 excel files and get the unmatched rows from sheet1 when compared to sheet2 in a results sheet.
How to get the row numbers of the unmatched rows from sheet1?
I am able to get the unmatched rows in result sheet, but again i have to go and search in sheet1 to check which row they belong to.
Can you please guide?
Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 12,000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
Sir i have an error in add data column "Add Data Column: Object reference not set to an instance of an object."
Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 9000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
When i wrote "CurrentRow.Item(0).ToString" i had error "unable to find available method "item"" Someone cam help please?
Are you using C# instead of VB as language? Else try write CurrentRow(0).ToString. Else check you For Each that it actually says CurrentRow there and not e.g. Row
@@andersjensenorg Thanks you so much! recreated the document and everything worked
Hi Everyone, I'm blocked with the if statement. I can't put the method .item for CurrentRow or CurrentLine.
I got the following error log message : 02/04/2022 21:04:57 1. Intersect UiPath Activities Update Column.xaml: 'DataRow' does not contain a definition for 'Item' and no accessible 'Item' extension method accepting a first argument of type 'DataRow' was found (is a using directive or an assembly reference missing?)
Can someone help me please?
Thanks by advance,
Maxime
Are you using C# and not VB (chosen by project creation)? If yes use [ ] instead of item.
You don't have to use item write CurrentRow("ColumnName") works fine also.
Thank you so much guys, it works perfectly now !
Keep pushing Anders, I will not miss any of your next videos !
Have a nice day
@@maximevernier6542 Nice to hear 🙂 Can you tell us, what went wrong/what you did? Kind regards, Anders
@@WakoKiler Thanks a lot, Marcin!