Okebiz Video Search



Title:UiPath | How to Read Excel Data, do an Online Search and write the result in the next Column | Guide
Duration:14:03
Viewed:13,866
Published:12-02-2020
Source:Youtube

In this tutorial, it's shown how to read Excel data from a column one by one and then doing an internet search and finally write the results into the corresponding column.

You could also watch:
🔵 UiPath Beginners Tutorial (+2 hours) - https://youtu.be/3ZKzTHdpsTs
🔵 Collection of UiPath Excel/Data Table Tutorials - https://www.youtube.com/playlist?list...

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. Afterwards we clear the Data Table except the column headers.

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

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

05:28​ Type Into
With the data from Excel we type into the online search field with an '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 to Excel (using the output Data Table).

Connect with me:
🔔 Subscribe - http://www.youtube.com/user/klogeande...
💼 LinkedIn - https://www.linkedin.com/in/andersjen...
👥 Facebook - https://www.facebook.com/andersjensenorg
💌 Email Newsletter - https://andersjensen.org/email-newsle...

#uipath#excel#rpa

SHARE TO YOUR FRIENDS


Download Server 1


DOWNLOAD MP4

Download Server 2


DOWNLOAD MP4

Alternative Download :



SPONSORED
Loading...
RELATED VIDEOS
UiPath RPA Beginners Tutorial [2020] UiPath RPA Beginners Tutorial [2020]
17:55 | 50,708
UIPath read excel and enter the data into web forms UIPath read excel and enter the data into web f...
42:22 | 12,863
How to extract Web Data to Excel with UiPath - Full Tutorial How to extract Web Data to Excel with UiPath - ...
13:51 | 668
UiPath Tutorial 08 A - Excel Automation in UiPath | Read Range and Write Range Activity | DataTables UiPath Tutorial 08 A - Excel Automation in UiPa...
19:59 | 25,556
UiPath - How to loop through rows and columns in Excel and pass values to web search/input UiPath - How to loop through rows and columns i...
05:03 | 11,216
How to do Web Scraping with UiPath - Use Case How to do Web Scraping with UiPath - Use Case
10:57 | 211
UiPath - How to Data Scrape from a web page and save to Excel - Full Tutorial UiPath - How to Data Scrape from a web page and...
06:15 | 10,881
UIPath - How to read Excel Data UIPath - How to read Excel Data
08:09 | 83,878


coinpayu