UiPath Tutorial 14 - Web Automation UiPath Example | Excel to Web Automation in UiPath

Hi Guys!
This video explains how to do Excel to Web Automation in UiPath.
Application taken for demo project - www.calculates...
The demo project reads the data (Height and weight) from excel, calculates the BMI and stores the BMI result back to excel.
Data table variable is taken to store the values read from excel.
==================================================================
Automation Anywhere Tutorial Playlist:
• Automation Anywhere A1...
Automation Anywhere A2019 Tutorial Playlist:
• Automation Anywhere A2019
UiPath Tutorial Playlist:
• UiPath Tutorial
JMeter Tutorial Playlist:
• JMeter Tutorial
Git and GitHub Tutorial Playlist:
• Git and GitHub Tutorial
Subscribe for more tutorials - / @qualityassurancelab7764

[@qualityassurancelab7764]

Hi Guys! Hope you found this video useful. Please like, share and subscribe to my channel. This will motivate me to create more good contents. Thanks!

[@harsharoyal5927]

Nice explanation Mam pls continue this series 🙏

[@sanyamjain6439]

This is the best, and i mean the best tutorial on uipath. You're gonna go straight to heaven trust me.

[@qualityassurancelab7764]

I am glad my videos are helpful to you, keep learning!

[@rimantasdanilevicius6754]

Love learn from your videos! Its better than watching TV show :D

[@qualityassurancelab7764]

Your feedback made my day 😀

[@ravireddy270]

Ur way of explanation nd the tone is just awesome

[@hariprasadreddy152]

Nice explanation mam but while converting into. Tostring function in calculator container it's not showing automatically while put row("Height(ft) "). Please suggest the issue which I was getting.

[@qualityassurancelab7764]

Is the project working when you added .Tostring manually?

[@RaMedha]

Can you share a video where we can supply username and password of a website and search for results based specific data element search? thank you

[@Artech.Ranjit]

I dont see attach browser and open browser things in my recent version. any idea how to handle? Thanks

[@lavakumara1732]

Hi please do facebook login and send massage to some one in UiPath web automation please

[@shareeverywhere3996]

I am facing object reference error / exception madam please reply

[@daneshwarinaduvinamani6276]

It will show only results of 4 four ,I want extra rows mam ,what can I do mam

[@sojolhamid6356]

I have a question. At first you include a activity "Open Browser", then you include "Attach browser" activity to include other more activities. If you include other activities directly just after "Open Browser" (eliminating Attach browser activity), will not it work? Please suggest anyone. Thanks in advance.

[@rockingram5183]

Very very worth ...pls do continue drop videos..glad to see this thank you

[@radenbayuherlambang3898]

I found error in for each "Object referance"?

[@kasimacsys1]

your videos are awesome👌👌👌

[@manisharathore23]

Hi , nice explanation Can you share selector video as well. Thank you

[@kaushik1286]

Mam it stops with just the first row, what do I do?

[@soubhagya.mani.3112]

It's very useful , thank you so much for your videos , keep it up sis

[@ujwalabamhane6944]

The way you teach is really awesome. Your voice is too good to listen. Keep up posting such helpful videos. Waiting for advance level project.

[@ujwalabamhane6944]

in above project, How to write result in the same excel itself in 'Result' column

[@qualityassurancelab7764]

Thank you so much! For advanced level project, please checkout below and I will post more such videos - Chatbot Integration - kzbin.info/www/bejne/lZCYnah5rtaigKs Project with ReFramework - kzbin.info/www/bejne/oJyampeCeJ6VfrM

[@qualityassurancelab7764]

@@ujwalabamhane6944 The result is written in the same excel as the Input data, do you mean something else?

[@learningneverends6674]

Nice explanation and useful video

[@audiohulkshare]

how you get a flowchart?

[@subbu4754]

very nice explanation

[@mvijay5286]

Pls telegram ink madam

[@daneshwarinaduvinamani6276]

Mam what about metric

[@tanveerkumbhari]

I was searching for this type of explanation..nice research work ..thanx

[@qualityassurancelab7764]

You are welcome, keep learning!

[@lucieyeung9036]

Thank you so much ! I love your videos !

[@saileshduttpadilam]

Thanks Mam, The video is absolutely understandable. I have a doubt here. I want to provide the values to the 'add data row' Activity through the Input Dialog Activity. Is it possible to do in that way? I have tried the same but not able to achieve that. Could you please help me on that?

[@qualityassurancelab7764]

Thank you so much. Do you mean instead of picking up data from excel, you are trying to take data from input dialog and store values in data table using 'Add data row'? If yes, this is possible, please let me know what issue you are facing

[@paulomartins9703]

Great video. One question, is it possible to copy a complete row from excel and paste it in a Web page, then do the same for 2 row, then 3...?

[@dust2dust61]

Many thanks

[@pramodjain6708]

Mam in the final output we have to click on "ok" button after every record is processed, can we automate that step as well?

[@qualityassurancelab7764]

There is no way to close message box without clicking on ‘Ok’ button. But, there are workarounds for the same. You can either Run a parallel robot that clicks on the ‘Ok’ button automatically or use a Callout Activity. You can also use Write Line activity which prints a string or the value of a string variable to the Output panel rather than a message box.

[@erwinator89]

If you just delete the message box, then the data will be stored automatically without the pop up

[@kalyang9950]

Thank you

[@22_gayatripotdar49]

Mam while running the program it shows error of 'flowchart' does not have a StartNode

[@humbertolimaferreira2587]

good afternoon, and you can check when i use the append range, the data is recorded, however if i open the file and make some changes and save the file and the robot will extract the data again for this file, it gives error !! ! .Or the excel files cannot be manipulated manually which gives the error? error that is giving is this "Append Range: Sequence contains no matching element"

[@deepakss1091]

superb stuff... need help on loading mutiple urls in a single browser window and covert into pdf. thanks in advance

[@qualityassurancelab7764]

Thank you, could you send me an email with detailed requirement at [e-mail]?

[@deepakss1091]

@@qualityassurancelab7764 could you help me to convert this html page into pdf and assign pdf name from a variable url: www.ti.com/product/BUF01900

[@harishsaraswathy7458]

Hi Mam..That was a clear and Beautiful explanation..Thanks!!

[@maazahmed2607]

Hey, Thanks for the amazing and detailed workshop, it has saved a fortune for us, which previously we were doing manually. I am not a professional Tech person but watching your video helped me create the bot. thank you

[@shuklasaurabh]

thanks........

[@riteshsaha4481]

How to clear all previously input data in a webpage at once without clicking individual type into field?

[@poojabkowshik8795]

Even after selecting the checkbox EmptyField for TypeInto, the values in height in inches and weight box are not getting cleared. can you help me in solving this issue

[@viratlilly3588]

#Quality#Assurance#Lab: First thing is, video was very nice. I have question : in regular Selenium we use POM where we reuse web elements, methods. How can we reuse functions? Can you please help me to understand?

[@bharathiganneboyina3724]

Thank You Mam. This video is really helpful for beginners , One request, could you provide the steps after calculating the value the data needs to send to Mail in another videos .

[@akshaywade9725]

How we can automate message OK button.

[@qualityassurancelab7764]

There is no way to close message box without clicking on ‘Ok’ button. But, there are workarounds for the same. You can either Run a parallel robot that clicks on the ‘Ok’ button automatically or use a Callout Activity. You can also use Write Line activity which prints a string or the value of a string variable to the Output panel rather than a message box.

[@g.hemamalinigovindhudu8894]

excellent very detailed explanation , Mam pls help me how to get text data from the disabled field in web app on ui path

[@vijaykallawar2342]

Can you make a video on Bulk logins, We need to take the logins credentials from Excel sheet or CSV file

[@arunkumar-eb9rx]

How to handle the pop up after clicking the calculate button ?

[@jyothiputchakayala1324]

Hello Mam I have one doubt dot matrix printed scann pdf extract is possible in uipath??

[@DFCE82]

Perfect execution, very nice tutorial 👏👏👏

[@sojolhamid6356]

Many Thanks. It's easy & quick.

[@Shiva05]

I have an Issue Validation Error Compiler error(s) encountered processing expression "row("Height(in)").ToString". 'row' is not declared. It may be inaccessible due to its protection level. Please Help me

[@Shiva05]

this is solved

[@qualityassurancelab7764]

@@Shiva05 Thanks for confirming

[@Scrottobaggns]

I have a username and password box, but the program runs too quick. I get half the login characters for the username appear in the password box. I've tried using a "wait for element to appear", but that didn't help...Please help.

[@Scrottobaggns]

Never mind i figured it out..I added a "DelayBetweenKeys" in the properties. That seemed to fix it. Nice video by the way.

[@premsudheer2092]

a very neat and clean presentation...

where is this automation package pls

[@qualityassurancelab7764]

Hi, which automation package are you looking for?

[@syed_sameer_ul_islam]

Hello mam my get text validation is getting error

[@Scrottobaggns]

I had something similar, I didn't have my text in double quotes. Once added it worked.

[@manishkumarsah6898]

helpful

[@Shiva05]

Compiler error(s) encountered processing expression "Result". 'Result' is not declared. It may be inaccessible due to its protection level. -this error shows, please help

[@qualityassurancelab7764]

which activity threw this error? What scope you set in the Result variable? The activity which threw the error, is Result variable in scope of that activity?

[@Shiva05]

@@qualityassurancelab7764 solved