| Solution |
| 1. | Create a 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.
|
| 2. | 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. Screenshot
2
- 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. |
|
Would you like a certified
automation consultant to automate this task for you? |
Automation Anywhere -
The Automation Software
