Extract Table Data from Web Page

[Rahul Sahoo]

Hi ,

My steps are -
Goto an website , where couple of links are shown
Click one link and
Move to the next page
In the next page you can get couple of links
(Name with "view profile" link)
For each link there have one view profile link
we should click the view profile link and goto the profile page and
extract the profile data and show in a excel sheet

Kindly let me know what are the steps where i will put the loop commands specially because i am unable to continue

[forumsupport]

Hello Rahul,

You need to insert nested loop in mentioned scenario. Main loop would be for total number of pages or loop until Next link exists and second loop would be for number of links on the webpage. Inside second loop, you can insert commands to click on 'View Profile' link, extract desired data into variable and use Excel commands to save that data in worksheet.

Text format of commands would appear something like this,

Loop While Next link exists
Extract Table to get all the links in CSV file
Loop for each row in Internet Explorer table
Extract Data
Excel Commands
End Loop
End Loop

If you can provide URL of website then we can create specific sample task for you.

Hope that helps.