UiPath | How to Read Excel Data, do an Online Search and write the result in the next Column | Guide

preview_player
Показать описание
In this tutorial, it's shown how to read Excel data from a column one by one and then do an internet search and finally write the results into the corresponding column.

You could also watch:

0:00 Intro

0:45 Presenting the Read Excel Search Online UiPath Case
In UiPath we want to read an Excel column, do an online web search, and then write the results back to Excel.

02:07 Read Range
Read the Excel data into a Data Table. We want to use the Data Table activities, because they are way more flexible than the Excel activities.

03:21 Create an Output Data Table
In order to not overwrite our existing data, we create an output Data Table to write our results to. Afterward, we clear the Data Table except for the column headers.

04:09 Open Browser
Opening an internet browser and navigating to our URL with UiPath.

04:49 For Each Row
We are iterating through each row of our input data table and doing the online searches with UiPath.

05:28 Type Into
With the data from Excel, we type into the online search field with a 'Type Into' activity in UiPath.

07:08 Get Text from an online search
Screen scrape the result of our online search with 'Get Text' (writing to our output Data Table).

10:39 Write Range
Write our results back to Excel (using the output Data Table).

Connect with me:

#uipath #excel #rpa
Рекомендации по теме
Комментарии
Автор

Thank you Anders. Your explanation is very helpful and very clear for beginners like me.

JohannesRickyEnggung
Автор

Great instructional video, love it cos it solves a real life problem. Newbie here, I have 2 questions:
1. can you explain the reason why 2 data tables are used
2. why you clear the 2nd data table

andyyeo
Автор

Hi Anders i m Daily viewer of your video.I love the way you explain everything. RRequest you to conduct session how to prepare for Ui Path Interview.

varunshinde
Автор

You're amazing! I made my first robot from the last video I watched. Took a lot of troubleshooting but it works great.

swagnugget
Автор

Hi Anders, thank you so much for these tutorials they have been extremely helpful, and I have been able to automate a big part of my repetitive tasks thanks to you and UiPath. Your work is much appreciated.

aldraq
Автор

Thank you so Andres much all the tutorials are so much helpful.

amk
Автор

Thank you so much anders. This tutorial is very helpful . Way to go :)

Learun
Автор

Many thanks Anders, it's the exact solution to a problem that I had!

michaeln.
Автор

Thanks for the Tutorial.... I wanted to automate the shopping website and i did it... Thanks a lottt :-)

kirankulkarni
Автор

Thank you, Anders. Your explanation is great and helped me to develop the code.

BayMax
Автор

You are doing great work. It's is helping a lot of people. But don't forget to mention every single small things.
Like to write in two columns, we write in add data row in array row variables with curly braket.
Yes, doing basic, was confused how to add. And I found your video.

akshayadak
Автор

I really love your tutorials! Thanks for sharing your knowledge, Anders.

sunsetcat_
Автор

Another Great video. btw i solved the rpa challenge, on the excel it was "last name " with an extra space and my data table list had "last name" with no spaces... dam ! it took me time to realize that.

Mantekz
Автор

thank you so much. Can you add another tutorial if you can't find any address ignore and move to next line ?

GPSniper
Автор

It is stopping if the search result is not found, so I think we should add one more step to the above video if you can explain that too it will be great. Thanks for the video man.

asanthosh
Автор

Thank you so much for this detailed tutorial ! Followed this logic with some modifications to extract data from a list of URLs. I just have one question, why do you create the second read range? Can't the "Add Data Row" simply overwrite the first read range table?

mostafaassaf
Автор

Excellent! Thank you so much! Could you please also teach us how to perform these steps on MS Power Automate?

philipea
Автор

Anders Jensen... You are the MAN ! First of all "THANK YOU VERY MUCH for giving this! You have taken your valuable time and made this for me, this means so much to me.
Helping to a stranger in time without any expectation and replying to messages is something i salute and you have undying gratitude for this !
I made my bot using this solution, there are 3 more steps i added to this based on my scenario that 1) "send hot key to end", 2) click validate another number, 3) If result is not correct then get the result populated as "incorrect", now it works like charm! This is just one part of my 12 scenarios in a bot.. If i have any questions I will ask you !
And, yes you pronounced my NAME CORRECTLY ! Thanks again Anders! :) :) :)

arunarumugam
Автор

Thankyou so much
love the way you did this

tarunsaini
Автор

Hi Anders, as always thank you for your RPA evangelism! May I just ask you why, in this case (and in general), do we need the "Clead Data Table" activity? Is it to reset somehow or what? Thank you in advance for you kind response.

blackmoonstudios