Unable to read numeric values from WebTable into Datatable

[Akhila]

[Parke]

Akhila:

You are grabbing the $ or the % signs. Similarly, you are grabbing all the values in the drop down lists and not the values that have been selected.
I believe GetCellData only grabs the (static) text in a webtable. To grab the dynamic data, we need to use the childItem method.

If my understanding is wrong, please let me know.
Try running the following code to get the values.

Code:

Set oWT= Description.Create() oWT("html tag").value = "TABLE" oWT("INDEX").value = 2 Set oTable = Browser("Mortgage Calculator").Page("Mortgage Calculator").WebTable(oWT) for j= 2 to 10 If j = 6 Then print "found "&j&",1 value = " & oTable.ChildItem(j,1,"Link",0).GetROProperty("innertext") Else If oTable.ChildItemCount(j,2,"WebEdit") = 1 Then print "found "&j&",2 value = " & oTable.ChildItem(j,2,"WebEdit",0).GetROProperty("value") ElseIf oTable.ChildItemCount(j,2,"WebList") = 1 Then print "found "&j&",2 value = " & oTable.ChildItem(j,2,"WebList",0).GetROProperty("value") ElseIf oTable.ChildItemCount(j,2,"WebList") = 2 Then print "found "&j&",2 value = " & oTable.ChildItem(j,2,"WebList",0).GetROProperty("value") print "found "&j&",2 value = " & oTable.ChildItem(j,2,"WebList",1).GetROProperty("value") End If End If Next

hth,

Parke

[Akhila]

Thanks Parke for your valuable information. Its really helpful for me.
I was breaking my head on how to capture current value in the field than capturing all existing values from the list.

and I also have no idea that Getcelldata captures only static values not the dynamic one.

I try out based on your suggested script

Thanks again !!