| 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. |
|
 |
| 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 >> |
|
