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

Поделиться
HTML-код
  • Опубликовано: 5 май 2020
  • Hi Guys!
    This video explains how to do Excel to Web Automation in UiPath.
    Application taken for demo project - www.calculatestuff.com/health...
    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

Комментарии • 76

  • @qualityassurancelab7764
    @qualityassurancelab7764  4 года назад +4

    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!

  • @ravireddy270
    @ravireddy270 3 года назад +2

    Ur way of explanation nd the tone is just awesome

  • @sanyamjain6439
    @sanyamjain6439 4 года назад +6

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

  • @rimantasdanilevicius6754
    @rimantasdanilevicius6754 4 года назад +4

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

  • @harsharoyal5927
    @harsharoyal5927 4 года назад +6

    Nice explanation Mam pls continue this series 🙏

  • @rockingram5183
    @rockingram5183 2 года назад +1

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

  • @maazahmed2607
    @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

  • @lucieyeung9036
    @lucieyeung9036 3 года назад +1

    Thank you so much ! I love your videos !

  • @ujwalabamhane6944
    @ujwalabamhane6944 3 года назад +2

    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
      @ujwalabamhane6944 3 года назад +1

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

    • @qualityassurancelab7764
      @qualityassurancelab7764  3 года назад

      Thank you so much! For advanced level project, please checkout below and I will post more such videos -
      Chatbot Integration - ruclips.net/video/__5luCyqoJI/видео.html
      Project with ReFramework - ruclips.net/video/jk7idLC9bHQ/видео.html

    • @qualityassurancelab7764
      @qualityassurancelab7764  3 года назад

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

  • @sojolhamid6356
    @sojolhamid6356 3 года назад

    Many Thanks. It's easy & quick.

  • @DFCE82
    @DFCE82 Год назад

    Perfect execution, very nice tutorial 👏👏👏

  • @tanveerkumbhari
    @tanveerkumbhari 4 года назад +1

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

  • @soubhagya.mani.3112
    @soubhagya.mani.3112 4 года назад +1

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

  • @kasimacsys1
    @kasimacsys1 3 года назад +1

    your videos are awesome👌👌👌

  • @subbu4754
    @subbu4754 2 года назад

    very nice explanation

  • @learningneverends6674
    @learningneverends6674 2 года назад

    Nice explanation and useful video

  • @harishsaraswathy7458
    @harishsaraswathy7458 Год назад

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

  • @premsudheer2092
    @premsudheer2092 2 года назад

    a very neat and clean presentation...

  • @dust2dust61
    @dust2dust61 2 года назад

    Many thanks

  • @poojabkowshik8795
    @poojabkowshik8795 3 года назад

    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

  • @manisharathore23
    @manisharathore23 4 года назад +1

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

  • @humbertolimaferreira2587
    @humbertolimaferreira2587 3 года назад

    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"

  • @kalyang9950
    @kalyang9950 2 года назад

    Thank you

  • @bharathiganneboyina3724
    @bharathiganneboyina3724 2 года назад

    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 .

  • @jyothiputchakayala1324
    @jyothiputchakayala1324 4 года назад

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

  • @Artech.Ranjit
    @Artech.Ranjit 2 года назад

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

  • @paulomartins9703
    @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...?

  • @sojolhamid6356
    @sojolhamid6356 3 года назад +1

    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.

  • @shuklasaurabh
    @shuklasaurabh 3 года назад +1

    thanks........

  • @hariprasadreddy152
    @hariprasadreddy152 3 года назад +2

    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.

  • @vijaykallawar2342
    @vijaykallawar2342 3 года назад

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

  • @arunkumar-eb9rx
    @arunkumar-eb9rx 3 года назад

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

  • @viratlilly3588
    @viratlilly3588 2 года назад

    #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?

  • @saileshduttpadilam
    @saileshduttpadilam 3 года назад +1

    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
      @qualityassurancelab7764  3 года назад

      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

  • @g.hemamalinigovindhudu8894
    @g.hemamalinigovindhudu8894 2 года назад

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

  • @22_gayatripotdar49
    @22_gayatripotdar49 2 года назад

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

  • @radenbayuherlambang3898
    @radenbayuherlambang3898 5 месяцев назад

    I found error in for each "Object referance"?

  • @riteshsaha4481
    @riteshsaha4481 3 года назад

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

  • @daneshwarinaduvinamani6276
    @daneshwarinaduvinamani6276 2 года назад

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

  • @manishkumarsah6898
    @manishkumarsah6898 3 года назад

    helpful

  • @pramodjain6708
    @pramodjain6708 4 года назад +1

    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
      @qualityassurancelab7764  4 года назад

      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
      @erwinator89 4 года назад +2

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

  • @kaushik1286
    @kaushik1286 2 года назад

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

  • @RaMedha
    @RaMedha 9 месяцев назад

    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

  • @shareeverywhere3996
    @shareeverywhere3996 2 года назад

    I am facing object reference error / exception madam please reply

  • @audiohulkshare
    @audiohulkshare 2 года назад

    how you get a flowchart?

  • @Scrottobaggns
    @Scrottobaggns 3 года назад

    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
      @Scrottobaggns 3 года назад

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

  • @Shiva05
    @Shiva05 3 года назад

    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

  • @deepakss1091
    @deepakss1091 3 года назад +1

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

    • @qualityassurancelab7764
      @qualityassurancelab7764  3 года назад

      Thank you, could you send me an email with detailed requirement at labqualityassurance@gmail.com?

    • @deepakss1091
      @deepakss1091 3 года назад

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

  • @akshaywade9725
    @akshaywade9725 4 года назад +1

    How we can automate message OK button.

    • @qualityassurancelab7764
      @qualityassurancelab7764  4 года назад +1

      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.

  • @daneshwarinaduvinamani6276
    @daneshwarinaduvinamani6276 2 года назад

    Mam what about metric

  •  3 года назад

    where is this automation package pls

  • @syed_sameer_ul_islam
    @syed_sameer_ul_islam 4 года назад

    Hello mam my get text validation is getting error

    • @Scrottobaggns
      @Scrottobaggns 3 года назад

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

  • @Shiva05
    @Shiva05 3 года назад

    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
      @qualityassurancelab7764  3 года назад

      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
      @Shiva05 3 года назад +1

      @@qualityassurancelab7764 solved

  • @lavakumara1732
    @lavakumara1732 2 года назад

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

  • @mvijay5286
    @mvijay5286 2 года назад

    Pls telegram ink madam