Count & Print all links from a webpage

-


'========================================================================
'Description: This function will print the number of links from any webpage
'========================================================================

Option Explicit

'Define variables
Dim lnk,colLink,lnkCounter,var

'Create the description object for links
Set lnk=Description.Create()
lnk("micClass").value="Link"
lnk("html tag").value="A"

'Get all the  Link objects from the page
Set colLink =Browser("CreationTime:=0").Page("micClass:=Page").ChildObjects(lnk)
For lnkCounter=0 to colLink.count-1
print colLink(lnkCounter).getroproperty("text")   ' print the link names
Next

'Release objects
Set colLink=Nothing

'Output from Google webpage "http://www.google.co.in/"

Comments

Post a Comment

Popular posts from this blog

Test Batch Runner - Run QTP Scripts from xls file

-
Image
To run QTP Scripts from a xls file we need to use QTP AOM. First we have to write following code in a vbs file and save it anywhere on your system. Option Explicit Dim qtp  Set qtp =CreateObject("QuickTest.Application") qtp.Launch qtp.Visible=True Dim xl,bk,s Set xl=createobject("Excel.application") Set bk=xl.Workbooks.Open("D:\QTPScripts\Test Batch Runner\TestBatchRunner.xls") Set s=xl.ActiveWorkbook.Worksheets("Sheet1") Dim RowNo RowNo=2 While trim(lcase(s.cells(RowNo,1)))<>"end" qtp.Open s.cells RowNo,1 Dim qtpTest 'Assign the data table path  qtp.Test.Settings.Resources.DataTablePath = s.cells(RowNo,2) ' Results Dim qtpResults                         Set qtpResults = CreateObject("QuickTest.RunResultsOptions")  'run the test qtp.Test.Run  qtpResults,True RowNo=RowNo+1 Wend 'Release Objects Set qtp=n...
Read more

Selenium: db and excel data into maps

-
package learning; import java.io.File; import java.io.FileInputStream; import java.io.IOException; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.ResultSetMetaData; import java.sql.SQLException; import java.sql.Statement; import java.util.ArrayList; import java.util.HashMap; import java.util.Iterator; import java.util.List; import java.util.Map; import java.util.Map.Entry; import java.util.Set; import java.util.TreeMap; import org.apache.poi.ss.usermodel.Row; import org.apache.poi.ss.usermodel.Sheet; import org.apache.poi.ss.usermodel.Workbook; import org.apache.poi.xssf.usermodel.XSSFWorkbook; import com.codoid.products.exception.FilloException; import com.codoid.products.fillo.Connection; import com.codoid.products.fillo.Fillo; import com.codoid.products.fillo.Recordset; public class uploadFileinMap { @SuppressWarnings("resource") public static void main(String[] args) throws IOException, FilloException, ClassNotF...
Read more

Python: get entire workbook data cell by cell

-
import openpyxl book=openpyxl.load_workbook("D:\\Automation\\QEDGE\\WorkingProject\\PythonLearning\\Resources\\excel.xlsx") sName=book.sheetnames for s in sName:     sheet=book[s]     #sheet=book.get_sheet_by_name("Sheet1") #     cells=sheet['A1':'B5']     for row in sheet.__iter__(): #         print(row)         for cell in row:             print(cell.value) book.close()
Read more