Reading Value from Java Table

[arjun.singh]

Hi All,

I have a javatable in which there are many values.Every time My QTP script is run, I would like to select a value from Javatable which has decription like "Interest"(say).How can I read Values in Java table and so that at the time of running of script,it seraches for "Interest" in Javatable and selects that cell.[/align]

[sreekanth chilam]

[/u]Hi Arjun,

Use "GetCellData" & "SelectCell" methods.

Syntax:
object.GetCellData(Row, Column)

Syntax:
object.SelectCell Row, Column

Check out the below example & implement accordingly.

Example:

Code:

Expected_Value="test"
RC=JavaWindow(..).JavaTable("Inter-cell spacing:").GetROProperty("Rows")
For i=1 to RC
     Actual_Value=JavaWindow(..).JavaTable("Inter-cell spacing:").GetCellData(i, 1)
     If (Expected_Value=Actual_Value) Then
        JavaWindow(..).JavaTable("Inter-cell spacing:").SelectCell i, 1
        Exit for
    End if
Next

[arjun.singh]

Thanks for the reply.It worked

[perplexed]

How can i compare an empty string in the above case ? I want to skip reading data from cells which are empty. thanks for the reply.

[Shridevi.Salagare]

Is there any way we can directly get the value of the row containing perticular value,Without traveresing the whole table everytime.
E.g

If in a table row 3 and column "operations" contains a value "insert",then is there a way we can get the row of the cell containing data insert directly without using cell by cell search?

[kotaramamohana]

Please check whether your webtable object supports below mentioned method.

Code:

object.GetRowWithCellText (Text, [Column], [StartFromRow])

[Shridevi.Salagare]

Hi kotaramamohana,

I am working on javaTable and object.GetRowWithCellText is not supporting.
Its showing errror.
Could you please suggest some other option?
In my project numerous times I have to do it and it takes lot of time to search cell by cell.

[Shridevi.Salagare]

Any suggestions ppl?
Please respond,as this would avoid lot of time in my project.

[sivaji]

Any suggestions ppl?
Please respond,as this would avoid lot of time in my project.