| Solution |
| 1. | Open the web page |
- Start Internet Explorer and specify
the URL of the webpage from which you want to extract data. (see
Screenshot 1 )
|
| 2. | Create a new task |
- Click on Tools->Task Editor
- Specify the command to select (Ctrl + a) and copy (Ctrl + c) the entire
webpage.
- Add the command to paste the contents copied into Notepad (Ctrl + v).
|
| 3 | Find the information
required |
- Specify the command to find the information required (Ctrl + f).
- In the Find window specify the information you want, for example Firstname and
press Enter. This command will find the word Firstname in the data
copied.
- Now we need to add the command to move to the beginning of the data to
be extracted (Right Arrow).
- Add the actual command to select (Shift + End) and copy (Ctrl + c) the
data from notepad.
|
| 4. |
Import data into Excel |
- Insert the actual Keystrokes (Ctrl + v) to import the data into
Excel.
- The above commands will extract and transfer the data for a single
field. If you want to do the same for all the fields you need to
insert a Loop List Variable command. The final task will look as shown in
Screenshot 2
- See how to create the task.
|
| |
| When you run this task, it will copy
the information required from the web page and paste it into
the an Excel worksheet. (see Screenshot
3) |
|
Would you like a certified
automation consultant to automate this task for you? |
Automation Anywhere -
The Automation Software
