How to find out row,column values to use GetCellData method

[quickmy]

I have an application and i am trying to capture a value which is inside the webtable. I am planning to use GetCelldata(row,column). When i try to use object spy on the object to find out the row and column values it doesnt list in either To properties or Ro properties of the object. Please help me how to find row,column values.

[niranjan]

Usually the columns and rows count either start with 0 or 1.
so Trail and error is the best possible method, i guess.

[swame_sp]

@ Quickmy,

can you elaborate ur question please....????
As niranjan said, you can start with 1 (most probably) and put the value in variable and cross check the value in the variable (by "watch"ing the variable)

[quickmy]

Thank you very much for the reply
I was using the previous thread's example appln http://www.seafight.com/
and trying to retrieve Online Now value ie 14.894

I am using

Code:

strCellData = Browser("Seafight.com – Online").Page("Seafight.com – Online").WebTable("Deutsch").GetCellData(row,column)

My doubt was how to decide on the values of row and column, Is it just the guess work?

[swame_sp]

Hi quickmy,

on looking at the link you have provided, the table has 3 columns and 6 rows....
Now either you have two options of hardcoding the value.

Either hard code the value of rows and columns.
say look for the data in row-2 and col-3
Or else verify for the value "ONLINE NOW:" (which is also hardcoding the data you are looking for) and in that row check for the value in the column 2 or 3.

For finding the row value, you need to have a for loop to match the value you need.

this either 2 or 3 is a guess.. you have to play around to find it out.
Once it is discovered i dont think the column values are going to be changing... only the row values can change...

Let me know if you can understand my logic.

[prince3105]

Code:

TableRowCount = Browser().page().WebTable().RowCount
TableColCount   = Browser().page().WebTable().ColumnCount
For i = 0 to TableRowCount-1
    For j = 0 to TableColCount-1
        CellValue = Browser().page().WebTable().GetCellData(i,j)
        Print "Row number - "&i
        Print "Column number - " &j
        Print CellValue
    Next
Next

[quickmy]

Hi swame_sp,prince3105,

Thank you so much for the explanation and the code, i got it right.
Here is what i have written

Code:

RCnt = Browser("Seafight.com – Online").Page("Seafight.com – Online").WebTable("Deutsch").RowCount
For i=1 to Rcnt
msgbox i
CCnt = Browser("Seafight.com – Online").Page("Seafight.com – Online").WebTable("Deutsch").ColumnCount(i)
For j=1 to Ccnt
strCellData = Browser("Seafight.com – Online").Page("Seafight.com – Online").WebTable("Deutsch").GetCellData(i,j)
Next
Next
'Using watch i get the i,j values ie 2,3 and i use them in GetCellData method
strCellData= trim(Browser("Seafight.com – Online").Page("Seafight.com – Online").WebTable("Deutsch").GetCellData(2,3))
strSplitData = split(strCellData," ",3,0)
onlineNow = strSplitData(0)
Msgbox(onlineNow)