| Solution |
| 1. |
Create task using Web Recorder |
- Create task by clicking on web recorder link in Automation Anywhere
main window.
- Specify the URL of the web page in which you want to record the task. For
our sample task we are using the support page in our web site
http://www.tethyssolutions.com/support_form.htm.
Screenshot 1
- Fill up the fields in the form and click on Submit.
|
| 2. |
Edit task |
- Edit the above task to read the values of the form fields
from an Excel spreadsheet.
- Select the Excel application in Automation Anywhere
- Open the Excel spreadsheet containing data to input in web form.
Screenshot 2
- Select the "Get Cells" option from Excel's 'Select Excel Command'.
Select the 'Multiple Cells' option from Excel's 'Get Cell'.
Specify the session name and range
of the cells. Screenshot 3
|
| 3. |
Process data to fill the web form |
- Type one by one excel columns data into the webpage
form.
- Check various conditions for OS as the data of
excel column(5).
- Use Backspace and F5 Keystrokes for the refreshing webpage.
- Loop it for each row in a excel dataset. Screenshot 4
|
| When you run this task, it
reads the values from a excel spreadsheet and inserts them one by one into the
webpage form. |
Automation Anywhere - The Automation Software
