Data Scraping [ Web To Excel ]

[Hacene_SENDEL (Shis52C)]

Dears,

I need your help to do Data scraping for web page and save the result to excel file as follows :

1- I need to open Main page which has a list of clickable items :
The Conjugator - Conjugaison et grammaire du verbe anglais

ScreenShot :

2. Get the lidt of ‘Infinitif’ verb from excel column ( saved from WebPage)

3. Click on each item to get the deatils as follows :
   

   

4. Save the result to Excel row as follows :
   

   

Note : Don’t care about the titiles of each column ( Présent, Présent continu, Prétérit, Present perfect … etc ) , just copy the content as explained in example above : from 1st item to last item ( it should be 102 items in total )

Thanks in advance

[AlfredSzene (Narcis Szene)]

Hi! What you can do in this case is the following:

1. Go to the webpage you mentioned

2. Extract the data that interests you (additional filtering can be done if you want)

3. The trick now is to automate the “clicking” on each verb, Instead of clicking, you will iterate through the verbs that you extracted and use Go To URL activity to go on the specific verb page. This can be done because the URL is a standard one that contains the verb in it. For this you can use String.Format() method to update the URL for each element.
   

   
   
   
   

4. Now just extract whatever you need from that page.

Let me know if this helps!