UiPath - How to loop through rows and columns in Excel and pass values to web search/input

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

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

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

    Check this playlist with all about Excel and Data Tables in UiPath: th-cam.com/play/PLXXz88_TPiHp_1N1pRURUpXnEt_quLyag.html

  • @rongkunzhao9119
    @rongkunzhao9119 10 หลายเดือนก่อน +1

    This is an awesome video!

    • @andersjensenorg
      @andersjensenorg  10 หลายเดือนก่อน

      Thanks a lot 🙌😎 Kind regards, Anders

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

    +1 for specifying the column name, thanks!

  • @V.MITHUNCHANNEL
    @V.MITHUNCHANNEL 4 ปีที่แล้ว +1

    Hi Anders
    Thanks for your excellent videos

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

    Very Helpful ...!

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

      You're very welcome, SUDERSHAN TIWARI - your support helps me a lot 😍

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

    Thanks, very helpful

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

      Hey Rosmyster. Thanks a lot for letting me know - it's really helping me a lot. Kind regards, Anders

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

    Thanks for the info Anders! If you wanted to highlight the excel row after the data has been loaded correctly how would you do that? I've managed to get the first row to highlight but not the following rows.

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

      Hey MyAdventureHat
      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

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

    Good Job :)

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

      Hey Mar, thanks a lot :) Kind regards, Anders

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

    Thank you for the videos.
    One question though, I have a excel containing list of url. I want them to open one by one. Did try assign a datatable value to a variable but don't know how to pass it to the open browser url field. I tried entering just the variable name but it does not work.
    Please help

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

      Thank you for your feedback 😊 Use a For Each Row and within you can use a row.item("strYourColumnName".ToString to get the content of each row. E.g. place it in a Type Into or a Browser scope. Kind regards, Anders

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

    Hi Jensen, once i get the result from web browser i want to copy into excel next column how do i do so? From your example, column A + Column B = Column C . I want to have the result in column C. Thank you!

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

      Hey Harry. How's tricks in Mainframe? 😀 To target Column C, we have an assign with row.item("yourColumnCName") = "result" Kind regards, Anders

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

    Hi Anders, how would you edit this workflow to log in to a website several times using user ids and passwords in an excel sheet? Trying to do this for our time recording system at work, having issues passing arguments between workflows - ie for each row in the table, take the employee id, then pass that to the next workflow which is opening the timesheet and entering the employee id. Any tips?

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

      Hey Whitevanqueen. Thanks for the question. At the moment, I’m on paternity leave, meaning I don’t produce videos and solve problems until the 23rd of August. Feel free to post the problem at my Discord, where many bright automation minds are gathered: th-cam.com/channels/Pdtz4gd_iYebJFYq9N8pWA.htmlcommunity?lb=UgxD1Qe9lWKL1I7HyAJ4AaABCQ Kind regards, Anders

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

    Soo cool

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

    Hi Anders, I have a question. I want to read the excel sheet and then I want to loop through the data in that sheet, while looping, when I loop through the first row of main spreadsheet I want the process to enter spreadsheet1 and get some data, do some operations and get back to main worksheet, loop through second row and enter to spreadsheet2 get some data there do some actions and then get back to main spreadsheet and so on. I want this to happen for all the rows which has data in main worksheet. Can you help??

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

      Hey Anu Negler
      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

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

    Hello Anders, I liked the video and replicated the same in my code but I am getting error "ui element not initialized". It is selecting the column values in the sheet but not displaying in web page as Set Text. Please let me know if you have any solutions.

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

      Hey Purushottam
      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 simply just 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

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

    Does it work if excel Is open in background and changing, please reply

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

      Hej Suraj. Unfortunately not. Then you have to run it again :) Kind regards, Anders

    • @surajpatil146
      @surajpatil146 3 ปีที่แล้ว

      @@andersjensenorg thank you... But instead of workbook I used excel scope and for each and used infinite while loop to continuously repeat process and it worked

    • @surajpatil146
      @surajpatil146 3 ปีที่แล้ว

      @@andersjensenorg and thank you so much for your video, because of your videos I was able to fully automate my day stock trading with excel

  • @taranveersingh93
    @taranveersingh93 3 ปีที่แล้ว

    I created a process to execute on multiple excel rows using “for each row”.
    It works fine except that it doesn’t repeat for the next rows.
    The process involves submitting one form and then it loads another page after which I’m done with one row. I added an activity to go back to the first page after the first row tasks are done.
    However, it still doesn’t repeat. When I remove the form submission on page one, the process repeats for all rows (form filling of all rows on single page minus submission and second page activities).
    What do you think I’m missing here?

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

      Hey Taranveer. Thanks for the question. At the moment, I’m on paternity leave, meaning I don’t produce videos and solve problems until the 26th of August. Feel free to post the problem at my Discord, where many bright automation minds are gathered: th-cam.com/channels/Pdtz4gd_iYebJFYq9N8pWA.htmlcommunity?lb=UgxD1Qe9lWKL1I7HyAJ4AaABCQ Kind regards, Anders

  • @777Donaldtrump
    @777Donaldtrump 4 ปีที่แล้ว +1

    I really appreciate you teach me a lot, I have already subscribe and like your videos. By the way, do you have any tutorial about passing data from one excel file to other excel file in "If then else" statement? As I want to get some data from one excel file and do some data filtering, then write to other excel file, I don't know how to define a variable to store the data from the excel file then pass to the new excel file. Would you please give me a hand?

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

      Hey Leung. Thanks for the question. At the moment, I’m on paternity leave, meaning I don’t produce videos and solve problems until the 23rd of August. Feel free to post the problem at my Discord, where many bright automation minds are gathered: th-cam.com/channels/Pdtz4gd_iYebJFYq9N8pWA.htmlcommunity?lb=UgxD1Qe9lWKL1I7HyAJ4AaABCQ Kind regards, Anders

  • @V.MITHUNCHANNEL
    @V.MITHUNCHANNEL 4 ปีที่แล้ว +1

    Hi had one scenario will it possible to provide a solution plz
    1.i had multiple excel files in data folder
    2.how to read the multiple excel files as a transaction data table and transaction Item using Reframe work ..if possible can u make a video tutorials plz
    Thanks in advance

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

      Hey Vasudevan. Check this REFramework tutorial, where I do transaction with a Data Table: th-cam.com/video/LP5y51_n6BY/w-d-xo.html Kind regards, Anders

  • @ramyameka3877
    @ramyameka3877 3 ปีที่แล้ว

    If we have no 4 rows and and many columns if in some rows value is condersider as null sobthat we should keep the status as not eligible how should do in uipath .. can any one help me out

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

      Hey Ramya
      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

  • @uipathbachir7610
    @uipathbachir7610 4 ปีที่แล้ว

    Great!

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

      You're very welcome, uipath bachir - your support helps me a lot 😍

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

    my uipath doesnt have .item() function. please help me on how i can get that

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

      Hey DaddyAIZEN💜
      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

  • @piraisoodanj2620
    @piraisoodanj2620 4 ปีที่แล้ว

    Can u post a video on "Loop through rows adding in excel sheet"

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

      Hey Piraisoodan, what do you mean by adding in excel sheet? Kind regards, Anders

  • @nicksun9607
    @nicksun9607 4 ปีที่แล้ว

    thx , teacher

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

      You're very welcome, Nick Sun - your support helps me a lot 😍

  • @bobforlyfe8005
    @bobforlyfe8005 3 ปีที่แล้ว

    Do you know loop condition if there is no more excel sheets, stop the loop

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

      Hey BobforLyfe
      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

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

    if it's date how do you do it

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

      Hey Dan Sumail Cannon Thanks for writing. I'm getting more than 50 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

  • @sudershantiwari6888
    @sudershantiwari6888 4 ปีที่แล้ว

    Volumes of thanks.

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

      Hey Sudershan. Thank you very much for taking you time to let me know 😊 Kind regards, Anders