Fill data from EXCEL on WEB FORM - UiPath RPA Tutorial

Подписаться 7 тыс.

Просмотров 32 тыс.

50% 1

In this video we will learn from scratch how to create UiPath RPA Automation that reads that from Excel file, and for each row of it, will fill data on web form!
Form used on the tutorial: forms.gle/eWV7zLfpn9PvCEve8
▶️ Checkout my UiPath course on Udemy: www.udemy.com/course/uipath-t...
✅ Did you like this video?
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
✍️ Leave your comment
📢 Share with friends
🕵 Follow me on social media ➽ linktr.ee/marcelocruz
#rpa #uipath #excel

Наука

Опубликовано:

2 июл 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 45

@sameerk12982 2 дня назад

Hello from India... Thank u very much for this extremely simple and helpful video.

@HongGheeTeo Год назад

Despite that UiPath has been updating their versions, your method continues to work! Your video has excellent examples and explanations.

@marcelocruzrpa Год назад

Thank you so much for the feedback! :)

@virtuallore 2 года назад

Very helpful and easy to follow. Thank you; this was just what I needed!

@marcelocruzrpa 2 года назад

You're welcome Janus!

@nikittabakerfenn4586 2 года назад

Easy to follow Tutorial. Thank you Marc

@marcelocruzrpa 2 года назад

You're welcome Nikitta!

@nandkumar9954 Год назад

Thanks a lot for such detailed video. Easy to understand and easy to follow. Kindly keep posting such videos.

@marcelocruzrpa Год назад

Thank you so much for the feedback :D

@virgilioalves319 11 месяцев назад

Very hepful Thank you

@andreewlucass7698 Год назад

Parabéns pela aula e conteúdo, você é fera !

@marcelocruzrpa Год назад

Muito obrigado pelo feedback Andreew!

@adriancunanan7162 10 месяцев назад

You're a pro thank you!

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

You're welcome Adrian! 😀

@harmeetkaur1372 2 года назад

Hi, great video. I am pretty new to UIPath. I want to extract data from the fields of one web form (user input), submit the form and load that data in another form in another application. The url for the web forms are dynamic, so I cannot use one specific url. Is it possible and if yes, can you please share any resource or video to follow? Thanks!

@fahimaftab9486 Год назад

Hello You method is just great. I have a question. Can you show how I can save web page as pdf on a specific folder with a sequencial name like 1, 2, 3 or a, b, c or A1, A2, A3 etc. Thank you

@Inuky 2 года назад

thank you so much :D

@marcelocruzrpa 2 года назад

You're welcome! :)

@huongphamthanh7597 2 года назад

Thank you very much

@marcelocruzrpa 2 года назад

You're welcome! :D

@sushmithaswamy8679 2 года назад

Thanks a lot

@marcelocruzrpa 2 года назад

You're welcome!

@arique.d3301 8 месяцев назад

Thank you.

@marcelocruzrpa 3 месяца назад

You're welcome!

@mariusonea2538 Год назад

what if the rows are generated by clicking "Add row" as in a list of products on a receipt?

@alperzarslan 2 года назад

Awesome! What if we have like 20 different fields and like 5000 rows? The running time would be crazy. Is there anyhow a more efficient way of dealing this? Additionally, is it charging a lot for the pro edition?

@marcelocruzrpa 2 года назад

Yes, It would take more time. There are some things that we can try to increase the automation speed, on thia video we have two tips to try ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-vOABUc844lE.html! Could you explain more in detail you're last question? I'm not sure if I understood well😃

@alperzarslan 2 года назад

@@marcelocruzrpa I mean the automation can be done i community edition for free, right? Alternatively, do we have to pay for the service in pro edition? I mean, what is the difference between pro and community edition?

@marcelocruzrpa 2 года назад

I don't know if I understood well, but I believe that you want to say 'Enterprise' instead of Pro. Yes you can do automations without cost on community edition. But If you want to scale, and run automations on many machines, you will need to have Enterprise edition, has it allows to add unlimited robots, has the Community has limit. Also you have access to UiPath Official support With Enterprise while Community Edition no, etc.

@martadawes 4 дня назад

This is not working for me in June 2024. I get the error "Non-invocable member 'CurrentRow' cannot be used like a method".

@maiashraf4312 Год назад

Great explanation ..... is there any way to match excel sheet columns with the form fields to avoid repetition of the "Type Into" activity

@marcelocruzrpa Год назад

Thank you, if you really want avoid the repetition of Type Into activity, you can invoke JS script to fill all the form fields at once.

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

it did not work@@marcelocruzrpa

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

Halo, i already try u'r tutorial. After click submit button, my data input not record on google form.even though my data in Excel already appears in the Google form. How fix this case?

@subhasishghosh2467 Год назад

Do we use the same process for CSV too. i.e get data from CSV and use it on application

@marcelocruzrpa Год назад

Yes it's almost the same, you would just need to replace the Read Range by the Read CSV activity.

@matthewuo1 6 месяцев назад

How to fill data form excel to dropdown or multiple choice.

@marcelocruzrpa 3 месяца назад

You can handle most of the times dropdowns in UiPath with the Select Item activity. If it doesn't work, you can always use one click activity to open the dropdown and another to choose the value from it.

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

how to input datetime from excel to from web divided into 3 input fields, for example from excel with format (DD-M-YYYY) to web format into DD, M, YY (into each field)

@marcelocruzrpa 3 месяца назад

First, you need to to parse the date and get it on DateTime variable. From that, you can easily get individually the year, month and day by just calling the variable + add dot and then choose what you want to get only (Month, Day or Year).

@srikanth1309 2 года назад

For me it is showing error ( currentrow cannot be used like a method )

@marcelocruzrpa 2 года назад

Hey Srikanth, what's the name of the tow instance on the For Each Row In Data Table activity? You should mention by the name defined, currently the default one it's CurrentRow