UiPath | How to Read Excel Data and Search Online and Write the Results back to Excel

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

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

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

    Thanks!

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

    Hi Rakesh thank you for this vedio,it is very helpfull to me when i got a task on to extract the data weather .and also i did this workflow i add three another columns to excel like perpitatin,wind ,status it is working fine.thank you so much.The way you are teaching is simply superb everyone can understand even the person from non it background like myself.

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

      I am happy to read your comment, Sravanthi. It's nice to see how you are able to utilize the contens created on my channel. Thank you and continue your learning journey. Good job Sravanthi!

  • @Maheshpatel-fy1tu
    @Maheshpatel-fy1tu 2 ปีที่แล้ว +1

    Love " Automate With Rakesh "

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

    Hey, Rakesh you are doing a very good job and your explanation is understandable. Could you plz tell me which version of the Uipath you used In this video?

  • @sandeepkamboj2499
    @sandeepkamboj2499 8 หลายเดือนก่อน

    Hi Rakesh,
    This video helps me a lot to understand how to extract the data from web page and it works very well for me. But one thing I want to know is if for example data is not available for a location like data for Delhi and goa is not available on the webpage or there is a message that no result found then how to skip these Delhi and goa location so that I can extract data of next locations. Hope so you will reply back soon on my query.
    Thanks!!

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

    great take ways from this session, but missing a normal use case like if no records found bot need to return some values great if we add it. Thanks

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

    Thanks for being an amazing teacher!

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

    I don't know why you don't have more views but the way you thought is amazing. You were clear at each and every step and I request you to continue making such helpful videos :)

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

      Thank you, try to share a word about our channel on various platforms you may like to

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

    Thank you brother working perfectly
    Good teaching with patience
    U have bright future brother

  • @Prasanakhandale
    @Prasanakhandale 8 หลายเดือนก่อน

    Thanks Rakesh i keep watching your videos. it's very helpful Yes i did make the bot.

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

    That’s quite helpful
    How can I get 5 lakhs items unique names from Google by using this method ?
    Also which tool I have to add ins in excel to get the data directly from Google?
    I have data in A column and want result in B column
    Already have names but I want unique names in respect of already have in excel sheet
    Which blue coloured UI tool you used for this ?
    Please help

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

    Hai Mr Rakesh,
    Thankyou for the video, very helpfull!!
    But i need your help,
    I already use get text also in our sequence and can copy automatically from website to excel, but the result for each row is same. Just like the loop read the same text.
    whats is the mistake please?
    Really need your help. Please and thankyou.

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

      Write get text output to a data table By using add data row Activity and finally write the datatable to excel

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

      @@AutomatewithRakesh yes. I already did this. Already use add data row activity then we use row.item("...",str...,str...) and use write datatable to excel.
      The sequence is running well. But the problem is already search with read the excel data (use each row) but the get text didnt follow to read the text that we want. 🥲🥲

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

    Hi Rakesh, Thank you for your videos. I don't find the activities you have used in my Uipath. I see the Uipath.Excel package with version 2.16.2 installed in my system. Could you please help me to get these activities. Please and thank you

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

    Great Job!! Can we do it for complex websites to harvest multiple fields of the data from the web page ?

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

    Can you please tell me " how to write extracted data into excel "(I extracted the data one by one from the yesbank stock page by using dynamic selectors and unable to write it in excel) which activity do I need to use after getting the values from the page .

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

      Use this concept th-cam.com/video/4ncVVSXRv14/w-d-xo.html

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

    Sir you did a very good and thorough Job in this video. It is very interesting

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

    Hlo bro i'm big fan of you, and your teaching is very nice and good explanation keep rocking 👍😍🥰

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

    Hi Rakesh, I am facing cannot read range error while trying to read the data from excel.. this is happening only with certain data .. any solution for this?

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

    Thank you very much Rakesh!

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

    Great job another time, keep doing like that! 👌

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

    Thank you so much ❤❤❤❤

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

    Good knowledge

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

    Thanks Sir 😊

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

    Can i get in touch with u? i have some clarifications on the same topic

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

    Thank you❤

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

      You are most welcome, Prethesh! Continue your learning journey and keep commenting!

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

    Can you please help in the below
    1. Read the data from database table
    2. Write the data to office excel.
    If this is not possible then we can go for below
    1. Read the data from excel
    2. Write the data in to office excel(excel online)
    Please help on this.

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

    Hey Rakesh, how does one read an excel file containing 3 different sheets and save it into one data table ?

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

      Use this 2 videos th-cam.com/video/qpoYbtRMBas/w-d-xo.html and th-cam.com/video/0bTajZXBBR0/w-d-xo.html

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

    Hi rakesh
    Can you explain difference between excel process and application scope with purpose of them

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

    I have recently installed UIPath, but my interface is so different as compared to you. Can you guide me to change my interface to look like yours.
    Thanks for teaching this

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

      Could you let me know what do you see it as different

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

      @@AutomatewithRakesh excel symbol is not showing and while you selecting 28 temperature that interface on right that am not gutting

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

      That could be because of the excel version you may be using. Tryto enter the values manually incase you still have issue or try to use the classic activities of Excel. To find Clasic Activities click on Activities panel > Click on Filter and Click on Classic Activity

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

    amazing!

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

    What if we have to type captcha before searching something.

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

    sir if one of the data is incorrect like location column what should I do for this?

  • @codewitheasy..9998
    @codewitheasy..9998 2 ปีที่แล้ว

    Pls create this project in reframwork

  • @Ak-vw3ww
    @Ak-vw3ww 2 ปีที่แล้ว

    Hi,
    I am getting this error- Could not find the user-interface (UI) element for this action.
    its only fetching first row data then getting error.

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

    Hii sir how too read data from excel and click on element .Please Help

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

    Hey,
    I get this error
    Main.xaml: Non-invocable member 'CurrentRow' cannot be used like a method.
    Can you please tell me How can fix it

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

      Double check the syntax, the currentrow is part of For each loop, shoulid avoid to be used as. methods.

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

    I want coaching pls give details

  • @Super-fo8jx
    @Super-fo8jx ปีที่แล้ว

    I Need Your Help

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

    My UIpath studio does not show Excel prosess scope even I go packeges please guide me..
    Thank you

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

      Click on Home settings and design and enable use modern design

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

      @@AutomatewithRakesh thank you sir.. very quick response

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

      @@AutomatewithRakesh tell me was old version please please

  • @Super-fo8jx
    @Super-fo8jx ปีที่แล้ว

    If I Want All USA Cities Contractora Data From Yelp Thorw Cities File