T85 - Excel to Web / Fill Web form from Excel |
Task Description |
Get Excel data from spreadsheet to fill web form.
 T85.atmn
Note: Save the .atmn file in My Documents -> Automation Anywhere -> Automation Anywhere -> My Tasks
|
| Solutions |
 |
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
- Fill up the fields in the form and click on Submit.
|
Screenshot 1
Screenshot 2
Screenshot 3
Screenshot 4 |
 |
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.
- 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.
|
 |
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.
|
When you run this task, it reads the values from a excel spreadsheet and inserts them one by one into the webpage form.
|
|
 |
| We started using this product to copy data from legacy system to new system. Now we use it just to do about anything automated. Countless hours saved. Thank you guys. |
- Jack Greenberg
|
| Read Customer Testimonies >> |
|
