How to Compare Excel Sheets in UiPath (Full Tutorial)

[@andersjensenorg]

Do you want to pass the UiPath Advanced Certification? Then learn UiPath REFramework: kzbin.info/www/bejne/goGYqmhnlNNpeLs 🙂

[@ErikSvedström]

Great video. Its so easy to follow and you make sure the viewer understands whats going on.

[@andersjensenorg]

Hey Erik, I'm so glad you found the video of use 🙂 Kind regards, Anders

[@lovemt4]

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

[@andersjensenorg]

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): kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@jeshjohansen]

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

[@andersjensenorg]

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): kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@sophochka]

Thank you for the lesson. It is very useful!

[@andersjensenorg]

Hey Пісоцька. Thanks a lot 😊 Have a great day. Kind regards, Anders

[@apocalipmon]

super helpful video !! thank you so much

[@andersjensenorg]

Hey apocalipmon - many thanks 💪🤩

[@waelkaabi2311]

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.

[@andersjensenorg]

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: kzbin.info/www/bejne/eWfbnnqcerFjbas Have a great day. Kind regards, Anders

[@Llenalolo]

Thank you so much Sir this is so helpful Thank you again god bless you

[@andersjensenorg]

You're very welcome, Rasha Alqahtani - your support helps me a lot 😍

[@sirishakolisetty1194]

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?

[@andersjensenorg]

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): kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@kunalmorande3224]

Can u please create a video on ci/cd pipeline for uipath

[@andersjensenorg]

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: kzbin.info/www/bejne/eWfbnnqcerFjbas Have a great day. Kind regards, Anders

[@maximevernier6542]

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

[@andersjensenorg]

Are you using C# and not VB (chosen by project creation)? If yes use [ ] instead of item.

[@WakoKiler]

You don't have to use item write CurrentRow("ColumnName") works fine also.

[@maximevernier6542]

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

[@andersjensenorg]

@@maximevernier6542 Nice to hear 🙂 Can you tell us, what went wrong/what you did? Kind regards, Anders

[@andersjensenorg]

@@WakoKiler Thanks a lot, Marcin!

[@andreirotaru.c]

Thank you very much for this great video/lesson😁

[@andersjensenorg]

You're very welcome, Andrei - did you build it yourself? 🙂 Kind regards, Anders

[@andreirotaru.c]

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

[@andersjensenorg]

Impressive, thanks for feedback 💪💪

[@malusingubane3293]

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

[@andersjensenorg]

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): kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@muhammadtaufikakbar7266]

Sir i have an error in add data column "Add Data Column: Object reference not set to an instance of an object."

[@andersjensenorg]

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): kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@svrinfo5440]

Hi Sir, Can please tell me how to write ahk script for alt+page down in one key?

[@andersjensenorg]

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: kzbin.info/www/bejne/qaGYi6p8gMubY5I Kind regards, Anders

[@IIAQET]

When i wrote "CurrentRow.Item(0).ToString" i had error "unable to find available method "item"" Someone cam help please?

[@andersjensenorg]

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

[@IIAQET]

@@andersjensenorg Thanks you so much! recreated the document and everything worked