Automation Anywhere Call: 1-888-484-3535   

 
Automation Anywhere
  Home > Product > Solutions > Web Data Extraction > T75  
T75 - Scrape tabular data from web and conditionally transfer it to Excel
Task Description
Scrape the tabular data from the web and conditionally transfer it to Excel.Solution

Solution
Create new task

  • Click on Tools->Web Recorder
  • Specify your website from where you want to scrape the tabular data.
    Click on Import Table in the toolbar on the bottom right hand corner of the screen.
  • Click on the table that has the data that you want to scrape for e.g. as shown in Screenshot 1.
  • Specify the path of the csv file where you want to import the data.
  • Click on Stop Recording and Save the task.

Screenshot 1



Screenshot 2



Screenshot 3
Import data into Excel

  • To import the data extracted the import table, into Excel based on certain conditions, you need to edit the recorded task.
  • Select the task in the Task List and click on Edit.
  • Insert a Loop for Each row in an Internet Explorer Table to process all the extracted rows.
  • Insert the condition based on which you want to filter the data. For e.g. the following screenshot shows how to avoid importing names that have last name as Smith.
  • Insert the actual Keystrokes to import the data into Excel.
  • The final task will look as shown in Screenshot 3
 
When you run this task it will extract the tabular data and conditionally import the data into Excel.
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

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 Customer Testimonies >>
  Products     Download     Purchase     Services     Support     Customers     Company     Sitemap     Trademark © Tethys Solutions 2008 Privacy Policy
View Demo View Demo