How to Compare Excel Sheets in UiPath (Full Tutorial)

แชร์
ฝัง
  • เผยแพร่เมื่อ 12 พ.ย. 2024

ความคิดเห็น • 39

  • @andersjensenorg
    @andersjensenorg  2 ปีที่แล้ว +4

    Do you want to pass the UiPath Advanced Certification? Then learn UiPath REFramework: th-cam.com/video/LP5y51_n6BY/w-d-xo.html 🙂

  • @ErikSvedström
    @ErikSvedström ปีที่แล้ว +1

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

    • @andersjensenorg
      @andersjensenorg  ปีที่แล้ว

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

  • @jeshjohansen
    @jeshjohansen ปีที่แล้ว +1

    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
      @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): th-cam.com/video/xWFz-S96XGo/w-d-xo.html Kind regards, Anders

  • @sophochka
    @sophochka 2 ปีที่แล้ว +1

    Thank you for the lesson. It is very useful!

    • @andersjensenorg
      @andersjensenorg  2 ปีที่แล้ว

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

  • @apocalipmon
    @apocalipmon 2 ปีที่แล้ว +1

    super helpful video !! thank you so much

    • @andersjensenorg
      @andersjensenorg  2 ปีที่แล้ว

      Hey apocalipmon - many thanks 💪🤩

  • @Llenalolo
    @Llenalolo 2 ปีที่แล้ว +1

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

    • @andersjensenorg
      @andersjensenorg  2 ปีที่แล้ว +1

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

  • @lovemt4
    @lovemt4 ปีที่แล้ว +1

    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
      @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): th-cam.com/video/xWFz-S96XGo/w-d-xo.html Kind regards, Anders

  • @andreirotaru.c
    @andreirotaru.c 2 ปีที่แล้ว +1

    Thank you very much for this great video/lesson😁

    • @andersjensenorg
      @andersjensenorg  2 ปีที่แล้ว

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

    • @andreirotaru.c
      @andreirotaru.c 2 ปีที่แล้ว +1

      @@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
      @andersjensenorg  2 ปีที่แล้ว +2

      Impressive, thanks for feedback 💪💪

  • @waelkaabi2311
    @waelkaabi2311 2 ปีที่แล้ว +2

    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
      @andersjensenorg  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: th-cam.com/video/C6xmGfEL07I/w-d-xo.html
      Have a great day.
      Kind regards,
      Anders

  • @sirishakolisetty1194
    @sirishakolisetty1194 6 หลายเดือนก่อน

    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
      @andersjensenorg  6 หลายเดือนก่อน

      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): th-cam.com/video/xWFz-S96XGo/w-d-xo.html Kind regards, Anders

  • @kunalmorande3224
    @kunalmorande3224 2 ปีที่แล้ว +1

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

    • @andersjensenorg
      @andersjensenorg  2 ปีที่แล้ว +1

      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: th-cam.com/video/C6xmGfEL07I/w-d-xo.html
      Have a great day.
      Kind regards,
      Anders

  • @malusingubane3293
    @malusingubane3293 2 ปีที่แล้ว

    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
      @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): th-cam.com/video/xWFz-S96XGo/w-d-xo.html Kind regards, Anders

  • @svrinfo5440
    @svrinfo5440 2 ปีที่แล้ว

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

    • @andersjensenorg
      @andersjensenorg  2 ปีที่แล้ว

      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: th-cam.com/video/sp5ZwFKfh-0/w-d-xo.html
      Kind regards, Anders

  • @muhammadtaufikakbar7266
    @muhammadtaufikakbar7266 ปีที่แล้ว

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

    • @andersjensenorg
      @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): th-cam.com/video/xWFz-S96XGo/w-d-xo.html Kind regards, Anders

  • @IIAQET
    @IIAQET 2 ปีที่แล้ว

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

    • @andersjensenorg
      @andersjensenorg  2 ปีที่แล้ว +1

      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
      @IIAQET 2 ปีที่แล้ว +1

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

  • @maximevernier6542
    @maximevernier6542 2 ปีที่แล้ว

    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
      @andersjensenorg  2 ปีที่แล้ว

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

    • @WakoKiler
      @WakoKiler 2 ปีที่แล้ว +1

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

    • @maximevernier6542
      @maximevernier6542 2 ปีที่แล้ว +1

      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
      @andersjensenorg  2 ปีที่แล้ว

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

    • @andersjensenorg
      @andersjensenorg  2 ปีที่แล้ว

      @@WakoKiler Thanks a lot, Marcin!