Working with Web Table

[Ilayaraja]

I have a web table where I am trying to get the value from a cell A (weblist) based on the another cell B (WebEdit).

For Example:
If cell B value = "Working" then i want to get the cell value A.

Problem:

I can't retrieve the data using getcell data (rowno,colno). It's showing blank. I am trying something like given below. Can you please help me get the code corrected?

Code:

Set Table=Browser("browser").Page("page").Frame("frame1").WebTable("Status")
        a = table.RowCount
        For Iterator = 0 To a-1

            Set Table=Browser("browser").Page("page").Frame("frame1").WebTable("Status")
            Set Desc = Description.Create
            Desc("micclass").value="Weblist"
            Set Childobj=Table.ChildObjects(Desc)
            Childobj(Iterator).Highlight
            StrStatus = Childobj(Iterator).GetRoProperty("value")
                If StrStatus = "Working" Then
                     Set Table=Browser("browser").Page("page").Frame("frame1").WebTable("Status")
                     Set Desc = Description.Create
                    Desc("micclass").value="WebEdit"
                    Set Childobj=Table.ChildObjects(Desc)
                    Childobj(Iterator).Highlight
                     C = Table.GetRowWithCellText(StrStatus)
                     D = Table.Getcelldata(C,9)

                 End If
Next

[Ankur]

What does the Object spy look like? Attach and upload the screenshot here , so that we can have a look.

[Ilayaraja]

  Desktop.zip (Size: 149.16 KB / Downloads: 107)

What does the Object spy look like? Attach and upload the screenshot here , so that we can have a look.

Hi,
 I have attached the snapshot for your reference. point to note: when i add the object in OR its taking as Browser: Page: Frame: WebTable: Element

But when i spy the object, spy shows as Browser: Page: Frame: WebTable: Webtable: Element (One more webtable is added in the hierarchy).

I want to capture the Submission number when the status is "working".

[Ankur]

Please edit your post above and attach the screenshot inline. (Under Attachments heading, after uploading the image, click 'Add Attachment' on the right)

[Ilayaraja]

           
















Admin Note: This is how we expected you to include and upload the attachments. We have gone ahead and done for you this time.