Automation Anywhere Call: 1-888-484-3535   

 
Web Data Extraction
  Home > Product > Solutions > Web Data Extraction > T56  
T56 - Extract data from a web page
Task Description
Extract tabular data from any web page. For example we will be extracting all sample tasks from Tethy Solutions Website.

Solutions
Create a new task

  • Click on New - > Task Editor




Screenshot 1



Screenshot 2



Screenshot 3


Screenshot 4
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.
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.
(Optional)Transfer all table date 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'
Automation Anywhere

Next Steps
Buy Now Buy now
Download Free Trial Download free trial
Compare versions Compare versions
Watch a flash demo Watch a flash demo
Contact me Contact me
Ask the Expert Ask the Expert
Request live demo Request live demo

Call 1-888-484-3535

Our Customers
ibounce

We started using this product to copy data from legacy system to new system. Now we use it just to do about anything automated. Countless hours saved. Thank you guys.
- Jack Greenberg

Read Customer Testimonies >>
  Products     Download     Purchase     Services     Support     Customers     Company     Sitemap     Trademark © Tethys Solutions 2008 Privacy Policy
Web Data Extraction (structured) Web Data Extraction Automation Anywhere Free Trial