Software Testing Learning Hub

Web Table in QTP

webtable

QTP helps to identify by providing Web table class. WebTable class provides various methods to work on web table. In this post we will look at the Methods and Examples to use them. Webtable class contains various methods which allows to work on tabular structure.Tables inside web pages are implemented without any name or id attributes most of the times. This makes it difficult for Automation engineer to create robust scripts for identifying the Table correctly at run-time. QTP by default uses the “index” ordinal identifier to recognized a WebTable.

 

 

Methods:

ChildItem
Returns a test object from the cell by type and index
Ex:

Set ChildItem = Browser("BrowserName").Page("PageName").WebTable("html
tag:=TABLE").ChildItem(2,1,"WebCheckBox",0)
ChildItem.Click

 

‘we have to pass row number, column number, Object type and Index(optional)

ChildItemCount
Returns the count of objects of a specific type in the specified cell.
Ex:

ChildItemCount=Browser("Browser").Page("Page").WebTable("html
tag:=TABLE").ChildItemCount(2,1,"WebCheckBox")
Msgbox ChildItemCount

 

ChildObjects
Returns the collecton of Child Objects Contained within the Object.
Ex:

Set ChildObject = Browser("Browser").Page("Page").WebTable("html
tag:=TABLE").ChildObjects
Msgbox ChildObject.Count

For i=1 to ChildObject.Count
msgbox i&" "& ChildObject(i).GetRoProperty("name")
Next

 

RowCount
Returns the number of rows in the table.

RowCount=Browser("Browser").Page("Page").WebTable("html tag:=TABLE").RowCount
Msgbox RowCount

 

ColumnCount
Returns the number of column in the table.
Ex:

ColumnCount = Browser("Browser").Page("Page").WebTable("html
tag:=TABLE").ColumnCount(2)
Msgbox ColumnCount

Note: we need to pass rownumber to know the column count

GetCellData
Returns the text contained in the specified cell.
Ex:

CellData = Browser("Browser").Page("Page").WebTable("html
tag:=TABLE").GetCellData(1,1)
Msgbox CellData

 

GetRowWithCellText
Returns the number of the first row found that contains a cell with the specified text.
Ex:

Msgbox Browser("Browser").Page("Page").WebTable("html
tag:=TABLE").GetRowWithCellText("Hello")

 


Refer the below sample code to work/handle a Web table.

rc =Browser("E-HRIS view employees").page("E-HRIS view employees").webtable("name:= Webtable_edit").Rowcount

'Above  rowcount property will return a integer of the total number of rows in web table.

msgbox rc

cc=Browser("E-HRIS view employees").page("E-HRIS view employees").webtable("name:= Webtable_edit").Columncount

msgbox cc

Webtable data validation-

Refer a below code to check or retrieve a data

Dim colref,actref

for c=1 to cc

if  trim(lcase  ( Browser( "E-HRIS view employees" ).page( "E-HRIS view employees" ).webtable( "name:= Webtable_edit" ).

getcellData(1,c)))="designation") then

msgbox c

End if

next