How to build a data driven Web automate

Automatic Form filling from an external file

WinTask can be used to automatically fill a Web form with the data stored in an external file. Instead of a user manually typing the data in the form, the WinTask script reads the first line of data in the external file, fills the form, clicks Submit, and loops in order to read all the lines.

In this Tutorial, we will use the script made in the Tutorial Automatic Web Form filling, and instead of using variables which are initialized within the script, we will initialize these variables from an Excel worksheet. And we will add a loop in order to process all the data stored in the Excel file.

Using WinTask Editor, we will modify the WinTask script written in the previous Tutorial. The steps are:

1. Declare the arrays which will contain the data read from the Excel worksheet
2. Populate the arrays reading the Excel worksheet
3. Replace the variables by the arrays element
4. Add the loop with a While...Wend block, a loop index i, and the ending condition for the loop

And we click Play for replaying the modified script.

See the Tutorial:

Automatic form filling using data read from an Excel file (Flash demo - 1 MB)