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

[@dawnfrappollo]

Thanks!

[@AutomatewithRakesh]

Thank you very much!

[@nukalasravanthi3945]

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]

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!

[@Abhishekrana.01]

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]

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

[@Maheshpatel-fy1tu]

Love " Automate With Rakesh "

[@shaziaansari2279]

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]

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

[@SadisticLlamaAC]

Thanks for being an amazing teacher!

[@shamilidevi3178]

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]

Use this concept kzbin.info/www/bejne/ap_Gh4mJjbepZ5Y

[@hendrysetiawan7516]

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]

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

[@hendrysetiawan7516]

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

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

[@pragateeshdharmaraj2262]

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

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

[@pabloredondo6662]

Great job another time, keep doing like that! 👌

[@Prasanakhandale]

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

[@AutomatewithRakesh]

Glad to hear that

[@sharin1982]

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

[@jayaramreddy4117]

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

[@AutomatewithRakesh]

Thank you Jayram 😍🙏

[@oluchioraekwe4245]

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

[@AutomatewithRakesh]

Thank you 🙏

[@mecayllabeukes1536]

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

[@AutomatewithRakesh]

Use this 2 videos kzbin.info/www/bejne/p6HSipWqh7J1l9U and kzbin.info/www/bejne/ZpO3kp2Qjad1iJI

[@mohanareddy6914]

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?

[@KaushikMyth05]

I want coaching pls give details

[@ashsulthan]

Thank you very much Rakesh!

[@AutomatewithRakesh]

You're most welcome

[@sridhanalakshmisaravanan250]

Thank you so much ❤❤❤❤

[@sandeepkamboj2499]

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

[@sunilchilampuri3382]

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]

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

[@sunilchilampuri3382]

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

[@AutomatewithRakesh]

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

[@isharoy2311]

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

[@santhoshkola2180]

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

[@AutomatewithRakesh]

Application scope was older activity

[@PretheshP]

Thank you❤

[@AutomatewithRakesh]

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

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

[@rasipogulabhaskar9858]

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

[@AutomatewithRakesh]

Click on Home settings and design and enable use modern design

[@rasipogulabhaskar9858]

@@AutomatewithRakesh thank you sir.. very quick response

[@rasipogulabhaskar9858]

@@AutomatewithRakesh tell me was old version please please

[@akshaykhanapure5034]

Thanks Sir 😊

[@AutomatewithRakesh]

You are welcome Akshay

[@ravikantyadav3015]

What if we have to type captcha before searching something.

[@doormanagementcounts5518]

Good knowledge

[@abhishekwable9134]

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

[@wizardcodes5341]

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]

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

[@Ak-vw3ww]

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.

[@codewitheasy..9998]

Pls create this project in reframwork

[@Super-fo8jx]

I Need Your Help

[@vky95]

amazing!

[@AutomatewithRakesh]

Thank you

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

[@Super-fo8jx]

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