filmov
tv
UiPath | How to Read Excel Data, do an Online Search and write the result in the next Column | Guide
![preview_player](https://i.ytimg.com/vi/9HxtyuAiPTk/maxresdefault.jpg)
Показать описание
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
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
Комментарии