T75 - Scrape tabular data from web and transfer it to Excel |
Task Description |
Scrape the tabular data from the web and transfer it to Excel.
 T75.atmn
|
| Solution |
 |
Record a new task
- Click on Tools->Web Recorder
- Specify your website from where you want to scrape the tabular data.
Click on Extract 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
Screenshot 4 |
 |
Import data into Excel
- To import the data extracted from 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 ‘Open Spreadsheet’ Excel command to open the excel file where you need to import the extracted data. You can find Excel command under ‘Applications’ command category.
- 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. Screenshot 2 shows how to avoid importing products that includes ‘AA Standard’ versions.
- Insert ‘Set Cell’ excel command to set the extracted value in excel. Screenshot 3
- Insert ‘Go to Cell’ excel command to go to one cell right or down.
- The final task will look as shown in Screenshot 4
|
 |
How to run the task:
- In case you do not have Automation Anywhere installed, please download and install it from, http://www.automationanywhere.com/download/freeTrial.htm
- Save T75.atmn under location, My Documents\Automation Anywhere\Automation Anywhere\My Tasks
- Copy Data.xls under C:\
- Launch Automation Anywhere and from Task List select T75.atmn and click on RUN button to run the task.
| |
| |
| When you run this task it will extract the tabular data and 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 >> |
|
