Task Description:
Extract tabular data from any web page. For example we will be extracting all sample tasks from Tethys Solutions website.
| Solution |
| 1. | Create a new task |
Click on New->Task Editor. |
| 2. | Capture the table |
- Under Internet category double click on Web Recorder command.
- Select the command Extract Table. Enter the website link which contains the tabular data and click on launch.
http://www.tethyssolutions.com/automation-samples.htm
- After the web page is loaded, click on capture button. A yellow tip appears with the text "Please click on the
table you want to capture." In the webpage, click on the table you want to import.
|
| 3. | Save the table data to .csv file |
After the table is captured, specify a valid path and a file name with .csv extension and click on Save. Screenshot 1
You can now open the .csv file in Excel or many other programs. |
| 4. |
(Optional)
Transfer all table data to another application |
Above step gets all the data in .csv file but alternatively you can get the web data one by one in loop
and perform additional actions on it. Let's say you want to get all the data from webpage and put them in notepad (for simplicity) in specific format.
- Under the Conditions /Loops category double click on Loop command. Select the option "Each row in an
Internet Explorer Table" and click on Save. Screenshot 3
- Under the Keystrokes /Mouse category double click on Insert Keystrokes command.
- From the Insert Variable list, select Table column. In next window select 1 for 1st column. Similarly repeat this for all the columns.
Screenshot 4
Note: To have proper spacing, insert a tab between each column.
Keystrokes: $Table Column(1)$[TAB]$Table Column(2)$[ENTER] in "Untitled - Notepad"
|
| |
| When you run this task, it launches the website and gets all data in csv file or optionally it loops through all the
rows and columns of the table, and prints it in a notepad.
Note: You can also use the pre-defined Template 'Extract Tabular Data from a Web page' |
Customer Testimony
"I LOVE Automation Anywhere! It's allowed us to stop paying a part-timer to scrape different websites for the data
we need, which was a tedious job to begin with. I was also very impressed with the support I received. I had a problem that AA support team was very responsive
and helpful with, time and again, until we figured it out. Great product, great support, great company! Thanks" - Joe Brillante, PostBankruptcy Report
Read more Customer Testimonies |
Screenshot 1:
Screenshot 2:
Screenshot 3:
Screenshot 4:
|
Automation Anywhere - The Automation Software