Automatic Request Submission and Results Capture

Create a loop for submitting n Web requests stored in an Excel file, capturing the result and writing back to Excel

In the following Flash demo, you will see how WinTask can automatize a Web request submission and store the result in Excel. Then we will add a loop to read each request to submit to the web site from an Excel file instead of submitting just one request.

We Record those steps:

1. Load a web page which gives the conjugation of verbs
2. Type one verb in the request field
3. Click Submit to display the conjugation for this verb
4. Capture the past conjugation from the displayed table
5. Click the Internet Explorer Close button

We will then Edit the script which has been automatically generated by Recording mode/Capture wizard and we will build a loop which reads all the verbs we want to know the past conjugation from an Excel A column, submits the request for each verb and captures the result. At the end of the loop, all the results are stored in column B of the Excel file.

See the Tutorial:

Data Extraction on multiple pages (Flash demo - 4 MB)